[SOLVED] INSERT WHERE

[denoteone]

Can anyone help me with the syntz to insert a value into a filed WHERE another field = $email? So far I have

 

$insert = "INSERT INTO users (password_key) VALUES ('$passwordKey') WHERE `email` = '$email'";
					$add_member = mysql_query($insert);

[Maq]

Why are you using INSERT?  That is for creating a new record...

 

Do you mean UPDATE?

[denoteone]

There is nothing in the password_key field yet. But I guess if they have to change their password again there will be something in that field. Can I use update even if the field is empty the first time?

[premiso]

There is nothing in the password_key field yet. But I guess if they have to change their password again there will be something in that field. Can I use update even if the field is empty the first time?

 

Yes, you can use UPDATE as long as the full record is there. (Even if some fields were not filled in the first time around).