You are here:
MySQL/Questions Answered by Expert stuart gregory
| Subject | Date Asked |
| Unset Array, Mysql Free Result and Memory usage | 7/8/2011 |
| Q: I’ve been religiously using mysql_free_result($result) after a query and unset($arrayName), whenever ... A: mysql free result will free all memory associated with the result. it can not increase memory usage. ... | |
| SQL Script to work with Javascript...follow up | 5/26/2011 |
| Q: the system didn't allow me for more follow-ups. Anyway, that is exactly what we need. Just to be ... A: Sorry i took it as you just wanted to show the image. you can not populate a sql query with ... | |
| SQL Script to work with Javascript: Window SetInterval & Location | 5/26/2011 |
| Q: I hope you can have a solution to my question since you work more in PHP and this is based in ASP ... A: Just been re-reading over this. so basicly the hasval increases with each page. as each page ... | |
| SQL Script to work with Javascript: Window SetInterval & Location | 5/26/2011 |
| Q: I hope you can have a solution to my question since you work more in PHP and this is based in ASP ... A: Use the SQL to populate the javascript array. once you have the sql array results use document.write ... | |
| SQL Script to work with Javascript: Window SetInterval & Location | 5/26/2011 |
| Q: I hope you can have a solution to my question since you work more in PHP and this is based in ASP ... A: I am sorry I am unable to give you a solution that will practically work well with that amount of ... | |
| Data Mismatch Error | 5/2/2011 |
| Q: I am tying to get a query to return a very simply result, in which the name of an account in my ... A: What i would use is somthing simple like below and then just expand if need be. $value = ... | |
| img size in the seperate column | 3/16/2011 |
| Q: Good Day!! and Greetings !!! Am using SQLyog. I need to get the img size in the seperate column. ... A: first of all on the upload execution script i would run a simple php script which will detect the ... | |
| A computer mystery | 1/17/2011 |
| Q: Stuart Hope you've been doing well. Ever since I've purchased a new wireless Microsoft mouse for ... A: This is not the right category for this question to be submitted to but as it happens i do know ... | |
| Connect MySql to SQL Server | 7/28/2010 |
| Q: I have a scenario where the primary database is mysql. Is there a way i can use a single query to ... A: This is not somthing that i have come accross or tried to do, I have looked into this and asked ... | |
| mySQL query search | 7/23/2010 |
| Q: I have a mySQL database with leads of businesses that's hosted online, and I need please the SQL ... A: This is a very simple mysql search string, this would consist of somthing like this $sql = "SELECT ... | |
| too many concurrent mysql connections | 5/31/2010 |
| Q: We have a livestock auction website where all animals sell at the same time. In 2 of our auctions, ... A: I have just tried to view the mysql processes via phpmyadmin and i have the same result, I wouldnt ... | |
| table field value not displaying | 5/11/2010 |
| Q: I have the following table: CREATE TABLE `tblCourses` ( `id` int(6) NOT NULL auto_increment, ... A: I have just selected you mysql code and inserted it into phpmyadmin, everything in php myadmin ... | |
| Storing file in Mysql | 2/22/2010 |
| Q: I want to store one file(pdf,doc,txt) in database. I searched in internet, but I am getting solution ... A: You can not store the file in the database, the file will be stored on the server and the database ... | |
| Swapping array key with one of the values in Mysql Result Array | 1/31/2010 |
| Q: $result = mysql_query("SELECT Stn_Code, name, col16, col17 FROM mis_stations WHERE year =2009 AND ... A: I think i understand what it is you want to do, which if i am correct there is a much simpler way to ... | |
| Swapping array key with one of the values in Mysql Result Array | 1/29/2010 |
| Q: $result = mysql_query("SELECT Stn_Code, name, col16, col17 FROM mis_stations WHERE year =2009 AND ... A: The Array value will always start at 0, PHP can manipulate the output but depending on how you want ... | |
| DB by PHP & MySQL | 1/22/2010 |
| Q: I'm looking for a best friendly and easy Administrative front-end Database using PHP & MySQL. I ... A: Do you have cpanel installed on your web hosting package? If so i would just use the phpmyadmin ... | |
| MS Access | 1/20/2010 |
| Q: Can you please help. I have a very simple database which has a "ProjectNumber" and "RefID" Fields. ... A: Its sometimes hard to convey what you mean on a subject you are struggling on. What you want to do ... | |
| Not able to add a second user in Mysql | 1/9/2010 |
| Q: On my Mysql 5 server, I’ve a user account as localhost | root | my-password with all ... A: CPanel is somthing that comes installed on your server. If you havnt got this installed then i dont ... | |
| Not able to add a second user in Mysql | 1/9/2010 |
| Q: On my Mysql 5 server, I’ve a user account as localhost | root | my-password with all ... A: I use the same set up as you and yes you can add a second user. It sounds like you havnt added him ... | |
| Help on getting Max and other values in corresponding rows | 12/1/2009 |
| Q: My requirement is to output the Maximum sale, Sales man-wise, Year-wise along with the other values ... A: I am Sorry that i have not responded untill now. I had gone to New York for a holiday. In order to ... | |
| How to find a unique id split into 3 tables efficiently | 11/16/2009 |
| Q: I'm new to MySQL and I have a problem. I'm dealing with 3 types of assets, for an example (and to ... A: I think i know what you are trying to do. are you trying to access this information from a web page? ... | |
| coding for free? | 10/8/2009 |
| Q: I've heard about Open Software, and Free Software, and all those projects that are carried on by ... A: You have raised a very good point, There is an artical coming soon on ... | |
| Calling Procedure | 10/7/2009 |
| Q: I have 80 procedures and I want to call all the procedure one by one Automatically and I am passing ... A: I am not use to using Toad, i tend to stay away from all programs like that for refrence to MySql, i ... | |
| Calling Procedure | 10/7/2009 |
| Q: I have 80 procedures and I want to call all the procedure one by one Automatically and I am passing ... A: How are you trying to run this script. If this is a script that a browser can call the information ... | |
| Cross checking Databases in mySQL | 9/28/2009 |
| Q: I'll preface this by saying that I haven't with a command line in any way shape or form in years, so ... A: I'm not fully sure what you mean here but heres what i think you mean, please correct me if i am ... | |
| MySQL CLUSTER INSTALLATION | 9/5/2009 |
| Q: I am confused with the installation procedures of MySQL packages, i have noticed, that to install ... A: I am sorry but i am unfermiular with that OS (CentOS 5.3, 32 bit platform.) and software does ... | |
| MySQL running locally? | 8/2/2009 |
| Q: Can a website with an SQL database behind it, be created and run on a local PC, or does it have to ... A: Yes you can use your own pc to run an sql database and a website. This would mean cconfiguring your ... | |
| Multiple Search Query | 7/27/2009 |
| Q: Can you please advise on the follow. I am currently using mysql and db2 and I would like to create ... A: There are a number of diffrent options avalible depending on what format you are coding your pages ... | |
| mysql | 7/21/2009 |
| Q: sir, i am student of Master of Computer Application from India I want to insert the two record in ... A: If i simply give you the answer that defeats the object. try reading up on mysql joins. If you ... | |
| php, database array | 6/17/2009 |
| Q: iam having problems trying to get an array working, i want to get all data from the database thats ... A: Arrays can be a little confusing, here is a basic array that will get the data from a database table ... | |
| Selecting a row in which to retrieve a value from a specific column | 6/16/2009 |
| Q: I have a really newby question that I am not succeeding to solve. If I want to show trough PHP the ... A: This is really simple to do. I can now help you with your script. I have wrote you a very simple ... | |
| Selecting a row in which to retrieve a value from a specific column | 6/16/2009 |
| Q: I have a really newby question that I am not succeeding to solve. If I want to show trough PHP the ... A: Can i just clarify a few things before answering this question for you. You want to select from ... | |
| Php & Mysql | 6/12/2009 |
| Q: I design a project on music album library in mysql(use as backend)& php (use as frontend). so how ... A: I am not sure what you are asking. Are you asking how to create a MySQL database table and what ... | |
stuart gregory
Top Expert on this page
Expertise
PHP html, xhtml, css coding and MySQL
Experience
My experiance is all first had as I am web developer and I have, and do build many websites all using php and mysql. This ranges from building a simple search engine to secure php login scripts. Some websites like http://www.web-application-development.info are complete database driven websites.
Organizations
I have a large number of websites which I host and maintain, such as.
http://www.webreger.com
http://www.protorrent.co.uk
http://www.web-application-development.info
http://www.mythslegendsandfolklore.co.uk
Education/Credentials
Web application development. (Open University)
BSC Honers Computing and development (Open University)
©2012 About.com, a part of The New York Times Company. All rights reserved.