"Continue" is a reserved word in mysql 5.0 (ref: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html )
I haven't tested it, but you should be OK if you backquote it as `continue` HTH Bruce On Tue, Aug 10, 2010 at 12:11 PM, Brendan Brink <[email protected]> wrote: > 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] > -- Bruce Clement Home: http://www.clement.co.nz/ Twitter: http://twitter.com/Bruce_Clement Google Buzz: http://www.google.com/profiles/aotearoanz "Before attempting to create something new, it is vital to have a good appreciation of everything that already exists in this field." Mikhail Kalashnikov -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
