Send email

[Hims15]

I am trying to send email which contains password of the user. i want to retrieve email id from database. and my password field and email field are in different tables.
I have tried but mail is not going to the email id.
Here is the code:
HTML:

            UserName: <input type="text" name="txt_usrnm"/>
            Security Ques:<select name="sec_ques_drpdwn">

                    <option>What is your academy's first number?</option>
                    <option>what is your nick name?</option>
                    <option>What is your favourite colour?</option>
                    <option>What is your pet name?</option>
                </select>
            Security Ans:<input type="text" name="txt_sec_ans"/>
        <input type="submit" name="submit" value="Submit" align="middle" style="width:auto" />

PHP code:

    <?php

    if(isset($_POST['submit']))
    {
        $usrnm=$_POST['txt_usrnm'];
        $sec_ques=$_POST['sec_ques_drpdwn'];
        $sec_ans=$_POST['txt_sec_ans'];


        $user_name = "root";
        $password = "";
        $database = "show_your_talent";
        $server = "127.0.0.1";
        $db_handle = mysql_connect($server, $user_name, $password);
        $db_found = mysql_select_db($database, $db_handle);

        if ($db_found) 
        {
            //print "Database Found ";
            $substr=substr($usrnm,0,2);

            if($substr=="AC")
            {
                $res="SELECT * FROM reg_ac WHERE UserName='".$usrnm."' and SecurityQues ='".$sec_ques."' and SecurityAns='".$sec_ans."'";
                $res2="select Password from username where UserName='".$usrnm."'";

            }
            else
            {
                $res="SELECT * FROM reg_indi WHERE UserName='".$usrnm."' and SecurityQues ='".$sec_ques."' and SecurityAns='".$sec_ans."'";
                $res2="select Password from username where UserName='".$usrnm."'";
            }




$result = mysql_query($res);
$result2 = mysql_query($res2);
$count=mysql_num_rows($result);
    if($count==1)
    {   
        echo "count";
        while ($row = mysql_fetch_array($result) && $row2 = mysql_fetch_array($result2)) 
        {
            echo "while";
            $from = "Name <[e-mail]>"; 
            $header = "From: ".$from; 
            //$header = "Reply-To: ".$from."rn"; 
            $to = $row['E-mail']; 
            $subject = "Password Recovery "; 
            $emailBody = "UserName ".$row['UserName']." 
            Password ".$row2['Password']." \n"; 
            echo $emailBody;
            echo $to;
        }


        if (mail($to, $subject, $emailBody, $header)) 
        { 
            echo "if mail";
            echo "<script type='text/javascript'> alert('Password has been sent to your email id.')</script>";
        }
        else
        {
            echo "Email not sent. Please, try again after some time.";
        }
    }
    else
    {
        echo "<script type='text/javascript'> alert('Wrong Question/Answer')</script>";
    }



mysql_close($db_handle);

        }
    }

    ?>

Its printing the message : Password has been sent to your email id.
But its not sending the email.

Please help me.

[sisindia]

Check row number 49. $to = $row['E-mail'];

Your message printing but the code is not getting proper email address from the database.

Check your output is correct based on your querry you are applying.

[gabrielcastillo]

Why not join your two tables if the primay index is the username for both.

I haven't tested this code out but in theroy it should work.

if( $substr=="AC" )
{
    $query = "SELECT user_tb.*, pass_tb.Password FROM reg_ac, username 
              WHERE user_tb.UserName = pass_tb.UserName AND user_tb.UserName = '$usrnm' 
              AND user_tb.SecurityQues = '$se_ques' AND user_tb.SecurityAns = '$sec_ans' LIMIT 1";
}
else
{
    $query = "SELECT user_tb.*, pass_tb.password as password FROM reg_indi, username 
              WHERE user_tb.UserName = pass_tb.UserName AND user_tb.UserName = '$usrnm' 
              AND user_tb.SecurityQues = '$se_ques' AND user_tb.SecurityAns = '$sec_ans' LIMIT 1";
}


$results = mysql_query( $query );


if( mysql_num_rows( $results ) == 1 ){
    $row = mysql_fetch_array( $results );

    echo "while";
    $from = "Name <[e-mail]>";
    $header = "From: ".$from;
    //$header = "Reply-To: ".$from."rn";
    $to = $row['email'];
    $subject = "Password Recovery ";
    $emailBody = "UserName ".$row['UserName']."
    Password ".$row['Password']." \n";
    echo $emailBody;
    echo $to;

}else{
    echo 'User not found!';
}

I reduced your two queries into on join therefore you only have one query to run.