Reset Password
$_POST['pass2'])
{
?>
query($sql);
//$result = mysql_query($sql);
if (!$result)
{
echo 'Could not run query: ' . mysql_error();
exit;
}
//$row = mysql_fetch_row($result);
$uemail = $result->fetchColumn(0);
//update password
$sql = "UPDATE user SET password = PASSWORD('$_POST[pass1]') WHERE email = '$uemail'";
// execute sql statement
$result = $db->query($sql);
$sql = "DELETE FROM password_recover WHERE email = '$uemail'";
// execute sql statement
$result = $db->query($sql);
?>
Your password has been reset
Please click here to log in.