Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Syntax problem...wtf?

Codes here !

Moderators: macek, egami, gesf

Syntax problem...wtf?

Postby bonkers » Sun Jun 15, 2003 5:43 pm

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

Code: Select all
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.
bonkers
New php-forum User
New php-forum User
 
Posts: 46
Joined: Wed Mar 12, 2003 7:17 pm

Postby liquedus » Sun Jun 15, 2003 6:42 pm

try this:

UPDATE user SET info="Yo Dawg...sup?", email="hi@ho.com" WHERE username="bonkers";
liquedus
php-forum Active User
php-forum Active User
 
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada

Re: Syntax problem...wtf?

Postby WiZARD » Sun Jun 15, 2003 11:21 pm

or this:
Code: Select all
UPDATE `database`.`user` SET info="Yo Dawg...sup?", SET email="hi@ho.com" WHERE username="bonkers";
User avatar
WiZARD
Moderator
Moderator
 
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol


Return to mySQL & php coding

Who is online

Users browsing this forum: Baidu [Spider] and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.