[PHP-DB] adding a mysql query as text into a history table... ?

2004-06-23 Thread Gawie Marais
hi guys, i have created a 'history' table and would like to insert the 'bare' sql query into that table just to check who did what on the database... now, i have this :- $CustUpdate = INSERT INTO record SET recid = '', customer_code = '$varCustomerCode', id_reg =

Re: [PHP-DB] adding a mysql query as text into a history table... ?

2004-06-23 Thread Jason Wong
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',

Re: [PHP-DB] adding a mysql query as text into a history table... ?

2004-06-23 Thread Gawie Marais
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