benfla

hi, I read the mysql tutorial on how to make it so you can have members on your site, but the password was randomly made and given to you so I decided to make a form so you can change your password the only problem is when I submit it it doesnt give me any errors, but it also doesnt update the information heres the code I\'m using now: <?php include \'db.php\'; if(!$yourusername){ echo "user name is a required field. Please enter it below.<br />"; } if(!$newpassword){ echo "new password is a required field. Please enter it below.<br />"; } if(!$currentpass){ echo "current password is a required field. Please enter it below.<br/>"; } include \'newpassword.html\'; exit(); if ($newpassword = $checkpassword){ } else { echo \'Your new password does not match!\'; exit(); } $encodedcurrentpass = md5($currentpass); $encodednewpassword = md5($newpassword); ($sql = mysql_query("UPDATE users SET password=\'$encodednewpassword\' WHERE username=\'$yourusername\' AND password=\'$encodedcurrentpass\'")); if (!$sql) { echo \'Your password hasnt been changed! there was an error changing your password\'; } else { echo \'Your password has been changed!\'; } ?> Im sorta new to this so i dont know whats wrong if you could help me I would really appreciate it.