insert mysql query into a history table... ?

[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 = '$varId_Reg',
date_added = '$getCurrentDate',
date_modified = '0000-00-00 00:00:00',
date_closed = '0000-00-00 00:00:00',
technician = '$varConsultant',
flag = '$flag',
contact_person = '$varContactPerson',
contact_number = '$varContactNumber',
contact_email = '$varContactEmail',
problem_type = '$varProblemType',
problem_description = '$varProblemDescription',
priority = '$varPriority',
technical_feedback = '',
customer_name = '$varCustomerName'
";

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

[Andy Barfield]

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 ?

[url]http://uk2.php.net/manual/en/function.addslashes.php[/url]

[Gawie Marais]

thanx guys.



"Gawie Marais" <gmlists@gam.co.za> wrote in message
news:cbbhk8$748$1@ctb-nnrp2.saix.net...

> 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 = '$varId_Reg',
> date_added = '$getCurrentDate',
> date_modified = '0000-00-00 00:00:00',
> date_closed = '0000-00-00 00:00:00',
> technician = '$varConsultant',
> flag = '$flag',
> contact_person = '$varContactPerson',
> contact_number = '$varContactNumber',
> contact_email = '$varContactEmail',
> problem_type = '$varProblemType',
> problem_description = '$varProblemDescription',
> priority = '$varPriority',
> technical_feedback = '',
> customer_name = '$varCustomerName'
> ";
>
> 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
>
>