Re: adding a mysql query as text into a history table... ?
| From: | Gawie Marais | Date: | Wed, 23 Jun 2004 10:53:14 +0000 |
| Subject: | Re: adding a mysql query as text into a history table... ? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34887@lists.php.net to get a copy of this message | ||
thanx guys.
"Jason Wong" <php-db@gremlins.biz> wrote in message
news:200406231743.39153.php-db@gremlins.biz...
> 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!
> */