[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 = '$varId_Reg',
date_added = '$getCurrentDate',
  date_modified = '-00-00 00:00:00',
  date_closed = '-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 = '-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

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', date_modified = '-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!
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 error :-
 
  Invalid query: You have an error in your SQL syntax near '2004-06-23
  11:09:57', date_modified = '-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!
 */

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php