You are here:
MySQL/Questions
| Subject | Date Asked | Expert |
| Unset Array, Mysql Free Result and Memory usage | 7/8/2011 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 ... | ||
| MsAccess | 10/25/2010 | Marty Landman |
| Q: I have a problem in extracting data from db. My db is user_table with parameters like code1, code2, ... A: Albo, Here's some code that I think would work: SELECT code1, COUNT(*) FROM user_table GROUP BY ... | ||
| Restore and Backup in MYSQL Problem | 8/31/2010 | Marty Landman |
| Q: .. here is my code for the backuping of my database public static String getData(String port, ... A: If your command was pasted and is literally what you wrote then I see the problem mysqldump -uroot ... | ||
| Restore and Backup in MYSQL Problem | 8/30/2010 | Marty Landman |
| Q: .. here is my code for the backuping of my database public static String getData(String port, ... A: Madzmar, I am not an experienced Java programmer and so can't help with that code. However you can ... | ||
| Connect MySql to SQL Server | 7/28/2010 | stuart gregory |
| 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 | stuart gregory |
| 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 ... | ||
| mySQL query search | 7/23/2010 | Marty Landman |
| Q: I have a mySQL database with leads of businesses that's hosted online, and I need please the SQL ... A: The specifics of the query will depend on the field names, but it would look something like SELECT ... | ||
| MySQL update using HTML form | 6/28/2010 | Marty Landman |
| Q: can you please tell me how to: 1. Update a row in a mysql database using an html form? 2. Delete ... A: The fact is a database cannot be updated or written to in any way directly from HTML. It can be ... | ||
| SQL code | 6/27/2010 | Marty Landman |
| Q: i am trying to use the SQL code to update one of my customer name from Mark Tobey to Mark Toby, may ... A: I answered this - UPDATE mytable SET fullname='Mark Toby' WHERE fullname='Mark Tobey'; That ... | ||
| code SQL | 6/26/2010 | Marty Landman |
| Q: what is the code to change the spelling of Mark Tobey to Mark Toby ? Thanks for your help. A: Desmond, There may be some details I can't supply because the question can be answered in a number ... | ||
| too many concurrent mysql connections | 5/31/2010 | stuart gregory |
| 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 | stuart gregory |
| 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 ... | ||
| MYSQL Beginner | 2/24/2010 | Marty Landman |
| Q: I am a Microsoft Certified Applications Specialist for Access 2007. I have been using Access for ... A: Charles I recommend you download in stall XAMPP http://www.apachefriends.org/en/xampp.html which ... | ||
| Storing file in Mysql | 2/22/2010 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 ... | ||
| Not able to add a second user in Mysql | 1/9/2010 | Marty Landman |
| Q: On my Mysql 5 server, I’ve a user account as localhost | root | my-password with all ... A: I have never added a Mysql user afaik directly on the table. It may be that the interface does more ... | ||
| Help on getting Max and other values in corresponding rows | 12/1/2009 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 | stuart gregory |
| 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 ... | ||
| backing up and restoring mysql | 6/30/2009 | Marty Landman |
| Q: Beginner question for you Marty. I wanted to use mysqldump to backup MySQL databases from my Redhat ... A: John, Looking at the discussion on http://littlelink.webtrouble.com/?WH5H I'm thinking that your ... | ||
| MYSQL CLUSTER | 6/23/2009 | Marty Landman |
| Q: I am much impressed with your profile. Now i have one question I Need to configure a MYSQL cluster. ... A: XAMPP will do this for you! http://littlelink.webtrouble.com/?ZLkd has the FAQ for Mysql using ... | ||
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.