Re: [PHP-DB] adding a mysql query as text into a history table... ?
On Wednesday 23 June 2004 17:14, Gawie Marais wrote: i would like to add the whole query into a text field in the 'history' table, but i get errors when i try to add it... can anyone help ? this is the error :- Invalid query: You have an error in your SQL syntax near '2004-06-23 11:09:57', date_modified = '-00-00 00:00:00', date_closed =' at line 6 You'll need to escape the string containing the query before you can insert it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* If you always postpone pleasure you will never have it. Quit work and play for once! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] adding a mysql query as text into a history table... ?
thanx guys. Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wednesday 23 June 2004 17:14, Gawie Marais wrote: i would like to add the whole query into a text field in the 'history' table, but i get errors when i try to add it... can anyone help ? this is the error :- Invalid query: You have an error in your SQL syntax near '2004-06-23 11:09:57', date_modified = '-00-00 00:00:00', date_closed =' at line 6 You'll need to escape the string containing the query before you can insert it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* If you always postpone pleasure you will never have it. Quit work and play for once! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Adding in MySQL
Dillon, John wrote: Can I UPDATE an int record with MySql and add 1 to it? without extracting it into a variable first? If so, what am I looking for in the www.mysql.com manual. Seems it only deals with SELECT and WHERE. Would have taken you two seconds to actually try this... UPDATE Table SET column = column + 1 -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php