Error in UPDATE query

[ThePhpReaper]

Well, i made a simple website that lets user create new accounts and edit their account information.

But at the edit script, the "UPDATE" query is having some problem.

I tried alot to solve it, but can find any way...

Herez the CODE:

 $query = "UPDATE registration SET firstname = '".$firstname."', WHERE user_id = '" . $_SESSION['user_id'] . "'";
                 mysql_query($query) or die(mysql_error());

Error i am getting:

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 firstname = 'Dave', WHERE user_id = '1'' at line 1

[flolam]

I guess it's the commas after registration and $firstname. Try removing them

[ThePhpReaper]

Still getting the same error  :'(

[MikeDean89]

The error you're getting is probably directed to the second comma you have in your query, see an updated query below.

 

$query = "UPDATE registration SET firstname = '".$firstname."' WHERE user_id = '" . $_SESSION['user_id'] . "'";
                 mysql_query($query) or die(mysql_error());

 

This should now work.

[ThePhpReaper]

That fixed the error.

Thnx a lot Dude.

[Maq]

Wasn't that the same thing flolam said?