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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
