[SOLVED] query

[unidox]

I have this query:

 

mysql_query("UPDATE `pcp_users` SET username = '$username', password = '$password', email = '$email', conf = '1', display = '$dname', name = '$name', description = '$info', age = '$age', dob = '$dob', country = '$country', location = '$location', interest = '$interests', website = '$website', aim = '$aim', msn = '$msn', yim = '$yim', icq = '$icq' games = '$games' WHERE user_id=$user") or die (mysql_error());

 

But I am getting this 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 'games = 'None' WHERE user_id=1' at line 1

[clanstyles]

its not a coma use AND instead

[akitchin]

actually, it IS comma-separated when one is using UPDATE.  the issue is that you're missing a comma before games.  as a hint, MySQL errors usually give you the string starting just AFTER the offending character(s):

 

, icq = '$icq' games = '$games' WHERE user_id=$user"

 

should be:

 

, icq = '$icq', games = '$games' WHERE user_id=$user"