[SOLVED] SQL Syntax Error

[refiking]

Where is the error?

 

mysql_query("INSERT INTO list (status) VALUES ('$status') WHERE name = $name")or die(mysql_error());

[lemmin]

Probably needs to be name = '$name'. Note the apostrophes.

[refiking]

Changed that and it still says the same thing.  What else could it be?

[lemmin]

Could you post what the error output is?

[refiking]

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 name = 'John' at line 1

[lemmin]

Oh. INSERT INTO adds a new row. You can't add a new row to a row that matches criteria. Are you trying to add a new row or change data in a current row? If you are adding a new row, just remove the where clause, otherwise you should be using UPDATE instead. http://dev.mysql.com/doc/refman/5.1/en/update.html