Replace?

[Anon]

ok, I've been trying for awhile now but I can't get this to work. I'm working on a script to edit a persons profile, but the mysql db isn't being updated. this is the code I'm using

mysql_query("REPLACE tq_users VALUES ('$id', NULL, NULL,'$password_1','$forgot_pw_q','$forgot_pw_a','$first_name','$last_name','$email','$birthday','$homepage','$icq','$aol','$yahoo','$biography')");

do you see something wrong?

[kparker]

For starters, how about testing the return code and then letting mysql itself tell you what's wrong (display the value of $php_errormsg if the query fails.)

[Anon]

ok, dumb mistake, I had added a column to the table and forgot to change the query, but I Have another question.
using replace, how do I make it so that certain values don't change?