[SOLVED] Updating two records in one table

[stelthius]

Hello all,

 

im using

    
$passReset = mysql_query("UPDATE users SET password='$db_password'  
                WHERE email_address='$email_address'");

 

To update the users password when they reset it but i also need to alter FLAG to 1 so it will bring up a alert for them to change there password from the one just sent to them, is it possible to do this ?

[pengu]

$passReset = mysql_query("UPDATE users SET password='$db_password',FLAG='1' 
                WHERE email_address='$email_address'");

 

Pretty sure it's just separated by a comma.

[stelthius]

Thanks Pengue, i thought it may have been i just wasnt sure so i figured id ask for a second opinion ill try it now.