Posted by schaeffer.kyle on 06/30/06 14:56

I've been working on a PHP/SQL page for the past few days, and for some
reason I'm having trouble updating/inserting new records in this
application.

I'm getting the following error message while trying to update or
insert a record:

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
'create='Yes',edit='Yes',finalize='Yes',admin='Yes',config='Yes'

This is the actual SQL statement that I am using:

UPDATE users SET
username='bob',password='password',firstName='Bob',lastName='Roberts',department='12100',view='No',create='Yes',edit='Yes',finalize='Yes',admin='Yes',config='Yes',userm='Yes'
WHERE userID = '1'

I'm not really sure where the synatx error could be. Any help would be
appreciated.

[Back to original message]