PHP - Recovery Of Datafields From A Special Get Form

Hi, im having trouble with the below code which is used in case user forgets password. If i enter username and ANY email, it will send there "Username" and "Password".  off course i just want it to be sent only to existing email in db. any ideas? Thank you.

<?
include("fns.php");
include "config.php";
if(isset($_POST['Submit'])){
//1. Check if form fields are filled in
if(!filledin($_POST)){
header( "Location:Messages.php?msg=7" );
exit();
}
$name=$_POST['name'];
$em=$_POST['mail'];

//2. Check if entered name exist

$query="Select pw from user where uname='$name'" or die(mysql_error());
$result= mysql_query($query);

if(mysql_num_rows($result)>0){
for ($i=0; $i<mysql_num_rows($result); $i++) {
$row = mysql_fetch_assoc($result);

$pass=$row['pw'];
$to="$em\r\n";
$from="From: \r\n";
$msg="Password:$pass\r\n";
$msg .="Username:$name\r\n";
$msg .="Your login information\r\n";
$subject=" Your Login Password\r\n";
}
}else{
header( "Location:Messages.php?msg=8" );
exit();
}

//4. Send password to user
if(mail($to,$subject,$msg,$from)){
header( "Location:Messages.php?msg=9&email=<?php echo $em; ?>" );
exit();
//echo "Please click here to log";
}else{
header( "Location:Messages.php?msg=10");
exit();
}
}

Hi,

I'm very new to PHP.

I've been working on this code for password recovery for a week and I'm pretty close, but I'm having problems understanding why I keep getting the:

"Can not send password to your email address".  I know for certain that it has found the email in the table, but why is it still having problems sending? There are no other error messages thrown.


Code: [Select]
function frm_lostpass()
{
global $skn,$In,$db,$Film,$Url,$Date,$module,$userinfo;
if(isset($_GET['check']) and trim($_GET['check'])=='ok')
{
$email = $In->get('email',0,'');
$sql_check ="SELECT Count(m.Email) AS numrows FROM tbl_member AS m\n"
."WHERE m.Email =  '$email'\n";
$numrow=$db->sql_get_first($sql_check);
if($numrow['numrows']!=1)
{
return "<center>Email not found !</center>";
}
else
{

global $skn,$In,$db,$Film,$Url,$Date,$module,$userinfo;

// value sent from form
$email_to=$_POST['email_to'];

// retrieve password from table where e-mail = $email_to
$sql ="SELECT m.Password FROM tbl_member AS m\n"
."WHERE m.Email =  '$email'\n";
$result=mysql_query($sql);

// if found this e-mail address, row must be 1 row
// keep value in variable name "$count"
$count=mysql_num_rows($result);

// compare if $count =1 row
if($count==1){

$rows=mysql_fetch_array($result);

// keep password in $your_password
$your_password=$rows['password'];

// ---------------- SEND MAIL FORM ----------------

// send e-mail to ...
$to=$email_to;

// Your subject
$subject="Your password here";

// From
$header="example@example.com";

// Your message
$messages= "Your password for login to our website \r\n";
$messages.="Your password is $your_password \r\n";
$messages.="more message... \r\n";

// send email
$sentmail = mail($to,$subject,$messages,$header);

}

// else if $count not equal 1
else {
return "That email address is not found in our database";
}

// if your email succesfully sent
if($sentmail){
return "&emsp;&emsp;Your Password Has Been Sent To Your Email Address.";
}
else {
return "&emsp;&emsp;Cannot send password to your e-mail address";
}



}
}
else
{
$skn ->set_file( 'lost_pass', 'member/frm_lostpass.html' );
return $skn -> output('lost_pass');
}
}

I am needing help designing password recover script.

This script must include a password recovery script.

I am needing for the person to reset there password, need to first answer a form named: Your Email.

If the email is found, it goes to another form that asks for the secret answer.

Then it goes to a form that asks the answer of there secret question that they entered when they first signed up.

If the answer is correct it updates the database table value of the password with a random string generated with:

abcdefghijklmnopqrstuvwxyz023456789

And it also, sends that password to the email provided.

What I am wanting to know, is how would the code with the if statements would be structured like and the column types and names.

Or if anyone has ever created something like this, and would be glad to post a snippet of there code would be great.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=314473.0

I created a form where someone can add their name and a comment and then submit it to my database.
here's the code of the form
  PHP