My first month in PHP HELP Please - Forgot password script

[omarfeb]

Hi and thank you for taking your time out in helping me.I have only been studying PHP for a month and I have recently
completed a login, logout and register form.

I decided to go for a forgot password form but I have no luck so far. Please help... thanks in advanced

it echo's out saying that I have sent an email with the password, but i still do not receive anything

ERROR MESSAGE:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

if (isset($_POST['submit']))
{	

mysql_connect("localhost", "username", "password") or die("could not connect to the database");
mysql_select_db("db_name") or die("could not select database");


$username = $_POST['username'];
$email = $_POST['email'];


$sql = mysql_query("SELECT * FROM `users` WHERE `username` = '$username' AND `email` = '$email'");
$result = mysql_num_rows($sql);


if (!$result)
{
	die (mysql_error());
}


if ($result == 1)
{
	$rows = mysql_fetch_array($result);
	$password = $rows['password'];
	$email = $rows['email'];
	$subject ="Password request";
	$header = "from: [e-mail]";
	$body = "Your password is " . $password; 

	mail ($email, $subject, $header, $body); 
	print("an email containning the password has been sent to you");
}else
{
	echo ("No such user exists in the system. Please try again");
}

}

?>

[rich06]

$sql = mysql_query("SELECT * FROM `users` WHERE `username` = '$username' AND `email` = '$email'");
$result = mysql_num_rows($sql);
....
$rows = mysql_fetch_array($result);

The query resource is in the variable $sql not the variable $result so the last line should read:-

$rows = mysql_fetch_array($sql);

rich

[omarfeb]

thank you so much the code fix you provided works just great.

but I am still clueless in why my email does not get sent and why the message

"an email containning the password has been sent to you"

Does not appear. It just shows a blank page.

[rich06]

mail ($email, $subject, $header, $body); 
print("an email containning the password has been sent to you");

your mail parameters are not quite in the right order email headers shoudl follow the email body.. so try as follows:-

if (mail($email,$subject,$body,$header)) { 
      print("an email containning the password has been sent to you");
}
else {
     echo 'Sending email failed...';
}

rich

[cretaceous]

How are you running PHP - on a local install of Apache on a windows box?
If so PHP mail may not run without taking care of some settings - should be fine on a proper web server