Password reset

[bravo81]

Hi all,

 

I have created a login system using php and have added a forgot password page as "forgotpass.php"

 

But i dont know what code i should use to get the page to check if $username & $email are from the same the users account.

 

its a basic form that asks for your:

Username:

Email:

Submit

 

i want the code to check that the username is in the database, then move on to check if the email given matches the one given with the username.

 

Any help would be appreciated, thanks

 

[GingerRobot]

It'll be something along the lines of:

 

<?php
$sql = "SELECT COUNT(*) FROM `yourtable` WHERE `email`='$email' AND `username`='$username'";
$result = mysql_query($sql) or die(mysql_error());
$num = mysql_result($result,0);
if($num != 1){
echo 'The information you entered does not match any account!';
}else{
//process password reset
}
?>

[bravo81]

Thanks alot, appreciate it!