Syntax problem...wtf?

A

Anonymous

Guest
I can't quite figure out what the syntax problem here is:

Code:
UPDATE user SET info='Yo Dawg...sup?', SET email='hi@ho.com' WHERE username='bonkers'<br>
<br>
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 'SET email='hi@ho.com' WHERE username='bonkers'' at line 1

Thats the output of my code. The top part is the query and the bottom part is the error :(... I'm really stuck on this one. Thanks in advanced for the help.
 
try this:

UPDATE user SET info="Yo Dawg...sup?", email="hi@ho.com" WHERE username="bonkers";
 
or this:
Code:
UPDATE `database`.`user` SET info="Yo Dawg...sup?", SET email="hi@ho.com" WHERE username="bonkers";
 
Back
Top