hi there, having trouble with a query that worked fine before in mysql4, but is causing the following error in mysql5
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'continue = '1' , finish = '0' , grandtotal = '40:0' where id = '1408'' at line 1 UPDATE IT_timesheet SET approved_by = '6185', supervisor_approved = '1', feedback_given = '1', continue = '1', finish = '0', grandtotal = '40:0' WHERE id = '1408' - all fields are in the table ok. anything stand out to anyone? -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
