This is my php code. whenever i am clicking on submit emails are going to everyone in

[Ankit Bhowmick]

while($religion_res=mysql_fetch_array($religiondata))
          {  
 
                  $_SESSION['registermail']=$email_res2=$religion_res['email'];
                  //$_SESSION['registermail']=$email_res1=$religion_res['email'];
 
 
 
                         if(($religion_res['education']==$education) || ($religion_res['religion_name']==$religion_name) || ($religion_res['height']==$height))
                   {
 
                ?>         
                        <tr>
                            <td></td>
                            <td class="text"><?php echo $reg_id=$religion_res['matri_id'];
 
                            $_SESSION['registerid']=$reg_id;
 
                             ?></td>
                     <td class="text"><a href="view_matchprofile.php?id=<?php echo $religion_res['matri_id']?>" target="_blank"><?php echo $religion_res['firstname']; ?></a>
                     </td>
 
                      <td class="text"><?php 
 
 
 
 
                     echo $religion_res['lastname'];
 
                      ?></td>
 
                     <td class="text">
 
 
 
 
                   <img src="http://bytes.com/topic/php/photos/<?php echo $religion_res['photo1'];?>" style="border:solid 2px #6f0c20;" width="30" height="30" />
 
                      </td>
 
                     <td class="text"><?php 
 
 
 
 
                     echo $religion_res['religion_name'];
 
                      ?></td>
 
                     <td class="text"><?php echo $religion_res['education']; ?></td>
                     <td class="text"><?php echo $religion_res['height']; ?></td>
 
 
                            <td width="140px">
                                <table align="center">
                                    <tr>
 
                                     <td style="border:none;"><a href="#">View Horoscope</a>
 
                                     </td>
                                    <?php
 
 
$interest=mysql_query("select * from register where email='$email_res2' && matri_id='$reg_id'");                                   
                                         $interest_data=mysql_fetch_array($interest);
                                         $email_res=$interest_data['email'];
                                         $matri_res=$interest_data['matri_id'];                                                                                
                                     if(isset($_POST['submit1']))
 
                                     {
 
 
                                //  echo $interest_data['matri_id'];
//                                          exit;
              $insert=mysql_query("INSERT INTO `expressinterest`(`ei_id`, `ei_sender`,`ei_receiver`) VALUES (NULL,'$email_from1','$interest_resf')");    
 
    $interest_resf=$interest_data['email']; 
 
 
 
 
                             $email_from1 = "[e-mail]";
 
                $email_subject1 = "Thank You for showing your interest";      
                  $email_message1 = "Thank You for showing your interest";                                                     
 
 
 
 
                // $email_message .= clean_string($name)."\n";
 
                    // create email headers
 
                $headers1 = 'From: '.$email_from1."\r\n".
 
                'Reply-To: '.$email_from1."\r\n" .
 
                'X-Mailer: PHP/' . phpversion();
 
                @mail($interest_resf, $email_subject1, $email_message1, $headers1);
 
 
             ?>
 
             <script>
         alert("send interest successfully");
             </script>
             <?php
                    }
 
?>
<!--<script>
function myFunction()
{
    window.location.href();
}
</script>-->
 
 
 
                                    <form action="" method="post" name="f1" enctype='multipart/form-data'>
 
                                    <td style="border:none;">
 
                                     <input type="submit" name="submit1" id="" value="Send Interest to <?php echo $religion_res['matri_id']?>" />
 
 
                                     </td>
 
                                    </form>        
 
 
 
                                    </tr>
                                </table>
                            </td>
                        </tr>
            <?php
         }
 
                  ?>

[Dormilich]

what’s the (full) question?

[Ankit Bhowmick]

Email should go to particular email id's. I know the problem why this is happening because submit button is in while loop. But i don't know how to resolve it.

[Dormilich]

Email should go to particular email id's.

what does it do instead?

[Ankit Bhowmick]

Its is a matrimonial site and there are some matching profile and a send interest button is present whenever i click on a particular send request button. Request should go to particular email id present in my database. I want to send email to a particular email id.

[RonB]

You need to fix your code formatting. Your indentation is very inconsistent making it very difficult to follow its logic.

Since you're sending the email inside a loop, I'd say that is the reason the email is going to more users than you intended.

What is the sql statement you used when assigning $religiondata? If that statement is returning more than one record, than I'd expect it very likely to send an email to multiple people.