password update

[kaos057]

I am making a password update script and i have it almost done. The only thing its not doing is updating the password.

if ($submit) {

$db = mysql_connect("localhost", "login", "password");

mysql_select_db("dbname",$db);

$result = mysql_query("SELECT id from members WHERE username = '$user' AND password = PASSWORD('$password')",$db);

if ($myrow = mysql_fetch_array($result)) {

  echo "IN\n";

  $sql = "UPDATE members SET password='PASSWORD('$password')' WHERE id=$id";

  $result = mysql_query($sql);

} else {

  echo "ERROR!\n";

}

} else {

I have the echo "IN\n"; line just to tell me if it was getting to that point which it is. I am guessing theres something wrong with the UPDATE line seeing how the only thing wrong is its not updating. Any help is appreciated.

edit: had to edit out user info 😉

[Tekron-X]

$sql = "UPDATE members SET password='PASSWORD('$password')' WHERE id=$id";

I think that the ' ' in the () is throwing it all off.

[kaos057]

nope that makes the password get changed to PASSWORD()

edit: Just got it after like 50 t&e's

$sql = "UPDATE members SET password=PASSWORD('$password')";

[Tekron-X]

no i mean the ' ' in the () ('$password') I think they should not be there

[suntra]

No, they have to be there. Not PASSWORD($password), but PASSWORD('$password')