MySql update?

[Kyle123]

if(isset($_POST['npassword']) and ($_POST['cpassword'])){
$npassword = $_POST['npassword'];
$cpassword = $_POST['cpassword'];
$username = $_SESSION['SESS_login'];
if($npassword==$cpassword){
$password = md5($npassword);
$lol = mysql_query("UPDATE `members` SET  `passwd` = '$password' WHERE  `login`= '$username';");
echo"Password Changed!";
}
}

 

It echos password changed, but its not updating the password. If I run it in phpmyadmin it works fine... So i'm really stuck.

 

[Maq]

Standard debugging - echo out your query and add or die() to your mysql_query call:

 

$query = "UPDATE `members` SET  `passwd` = '$password' WHERE  `login`= '$username'";
echo "Query: " . $query;
$lol = mysql_query($query) or die(mysql_error());