PHP and MySQL

[big_e]

I'm making a PHP4 script that uses a MySQL database and I'm having some trouble.j I'm trying to update a record in the MySQL database but not having much luck. Here is my code:

mysql_query("INSERT INTO counterdata (password) WHERE username = '$curuser' AND password = '$curpass' VALUES ('$newpass')");

It would post to the database before I added the WHERE command but it would post anywhere. Now it won't post at all. Any ideas?

[monkey]

2 things wrong with that..
1.) You left out the semi colon at the end of the query
2.) Actually, that query may be completely wrong. Ive never seen it work, but maybe its something Ive never used.. this should work..

mysql_query("UPDATE counterdata SET password='$newpass' WHERE username='$curuser' AND password='$curpass';");

[big_e]

That worked great, thanks for your help!

[[deleted]]

Indeed the sql statement is completely wrong.
INSERT always creates a new record, so the WHERE clause never applies.

Using errorchecking, the mysql server will warn that the query is bad, and tell you that the error starts at "WHERE".