Re: adding a mysql query as text into a history table... ?
| From: | Jason Wong | Date: | Wed, 23 Jun 2004 09:43:39 +0000 |
| Subject: | Re: adding a mysql query as text into a history table... ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34885@lists.php.net to get a copy of this message | ||
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 = '0000-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!
*/