|
|
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.
Navigation:
[Reply to this message]
|