Update Table Where User = x

[Oni]

Hello,

I have a simple problem with a line of code. I'm not sure about in what order and how I should write this and I can't find the answer on google.

Help appreciated 😉

$put="UPDATE users WHERE User = '$user' SET ip='$ip'";

$results = mysql_query($put)
or die(mysql_error()); 

Error:
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 'WHERE User = 'admin' SET ip='139.179.155.211'' at line 1

[mchip]

http://dev.mysql.com/doc/refman/5.0/en/update.html

[bbreslauer]

It should be SET, then WHERE.

[Oni]

Works, Thanks!