mysql UPDATE

[admin]

I want to update a friends password, his name is on my db John. I tried following but as you will notice there is nowhere set that the query should change johns password.


$sql = "UPDATE Members Set Password = $newpass WHERE Passwort = $oldpass";


How should the query be ? (the name of the table is friends the field where my friends names are in is called Name and the password field is called Password)

thanks in advance

ali