My issue is when the form is submitted it sends an email alerting other users that have previously filled a survey for that exact camp that a new survey entry has been entered for that camp location, the problem is if the person has entered 3 surveys for that camp location the user gets 3 emails, Since my database has sometimes has entries from the same user email for each camp location.

This is what is the problem 

$to\_add = $row['Email'];

How do I make sure it does not send an email to the user multiple times?

```
$query2 = "SELECT * FROM Camp_Survey_Submits WHERE CampName = '$campname3'";
$result = mysql_query($query2) or die(mysql_error());
while($row = mysql_fetch_array($result)) {

$from_add = "support@hikelospadres.com"; 
$to_add = $row['Email']; 
$subject = "New Report Has Been Submitted to ".$row['CampName']." ";
$message = "Hello ".$row['SurveyorName'].", <br>
We noticed that you have previously filled out a survey for ".$row['CampName'].", so we just wanted to inform you that a new report has been added to ".$row['CampName'].". <br>  To see this latest report, please go to: <a href='".$row['Referrer']."'><b> ".$row['Referrer']." </b></a>. <br>
Thank you,<br><br><br>
<b>Hike Los Padres<b><br>
www.hikelospadres.com<br>

```

`