mySQL problem updating database

[nmcglennon]

Ok... I am writing a login page using sessions. I go tit to work, but I am having trouble getting it set up so the user can change his password. I keep getting an error when I submit the data.
I have otherwise gotten this to work correctly, I just have an error in either $newpass or $sql. Any help would be appreciated.

...

// Error must be in either $newpass or $sql

$newpass = substr(md5($newpw),0);
$sql = "UPDATE member SET
password = PASSWORD('$newpass'),
WHERE username = '$newid'";

if (!mysql_query($sql)) // I do receive this error
{
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact [e-mail].");
}

...

Thanks in advance...

[ryan_dodd]

quick question - did you try just:

$sql = "UPDATE member SET
password = '$newpass'
WHERE username = '$newid'";

hope it works... if not let me know what that string gives you when u exequery....

[Traduim]

I think you mised the ' '

$sql = "UPDATE member SET
password = 'PASSWORD('$newpass')',
WHERE username = '$newid'";

[nmcglennon]

its ok... I just decided to drop any sort of encryption at all. Thanks for the help though. I got it to work with out the scrambling of the passwords.