[SOLVED] Help with UPDATE (it said REQUEST before..I'm too tired for this..)

[jlange]

I'm pretty much new to MySQL, but I understand the concepts (I think). I'm having issues with a MySQL query through PHP.

 

$query= "UPDATE logon SET (username,password,firstname,lastname,room) = ('$username','$password','$firstname','$lastname','$room') WHERE id = '$id'";

 

That's the code. It tosses this error at me:

 

UPDATE logon SET (username,password,firstname,lastname,room) = ('schmultz','math','John','Schmultzee','200') WHERE id = '1'. 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 '(username,password,firstname,lastname,room) = ('schmultz','math','John','Schmult' at line 1

 

Help?

 

 

edit: server version...oh shoot I don't know. It's their newest stable release.

[skali]

UPDATE logon SET username='schmultz',password='math',firstname='John',lastname='Schmultzee',room='200' WHERE id = '1'

[jlange]

Hmm, now its telling me this:

 

Error in query: UPDATE logon SET username='schmultz',password='math',firstname='John',lastname='Schmultzee',room='200' WHERE id = '1'. Duplicate entry 'schmultz-1' for key 1

 

Could be my poor table-setting-up skills.

 

Any thoughts?

[jlange]

This might be it: the id column, I have set to auto-increment, isn't auto-incrementing.

 

[jlange]

Fixed 

 

For some reason or another, I had two columns set as keys, so I just made id the only key (makes sense to me).