SQL parse error

[Anon]

$sql = "UPDATE user SET check = '.md5($newpass).' WHERE
uname='$uname';

I am getting a parse error, anybody have any ideas?

thanks
anthony

[Anon]

try the following if you want md5 to be executed by the php server

$sql = "UPDATE user SET check = '".md5($newpass)."' WHERE
uname='$uname';

or
if you want md5 to be executed by the database server(This will most likely only work in MySQL and Postgres)

$sql = "UPDATE user SET check = md5('$newpass') WHERE
uname='$uname';

[Anon]

$sql = "UPDATE users set check = 'md5($newpass)' WHERE uname='$uname';

Or that.
Thanks

[Anon]

if (isset($newpass)) { echo ("nothing in the box"); } else {
$db = mysql_select_db("pinehead",$con) or die("error");
$check = md5($newpass);
$sql = "UPDATE users set check = '$check' WHERE uname='$uname';
$result = mysql_query($sql,$con) or die("error");
}

Ok that is what it ended up to be.. A) i get a parse error, 😎 is their a better way to do it.. Wanna help me out? ia mabout to throw my damn computer out the window.
Thanks
Anthony

[steveness]

Try two changes - first, have PHP run the hash, second, put a final quote on the sql.

As in:
$sql="UPDATE users SET check = '".md5($newpass)." WHERE (uname='$uname')";

That should do it. Or not.

steveness