Looping

[Anon]

I am sending mail to a users in a MySQL table. Everything works fine except for some odd reason i just tested it and it would mail every user twice. Is there a way to ONLY send the mail to each row in the table ONCE or prevent it from sending more then one?

[Anon]

Let's see your loop code...

[Anon]

$query="SELECT email FROM user";
$result=mysql_db_query($database_name,$query,$conn) or die("Database Error");
while($r=mysql_fetch_array($result))
{
$email = $r["email"];

mail("$email","$subject","$text",
"From: Whoever <[e-mail]>\nX-Mailer: Bob\nReply-To: [e-mail]\n") or die("Error sending mail");
}

[Anon]

Maybe try
$query="SELECT DISTINCT email FROM user";

[Anon]

Stupid question, maybe: are you using Netscape? Maybe you resized the window, and resubmitted the request, ya know? I hate when Netscape does that.... How many times did you test the mass-email? Instead of mailing to the email address, just echo them to make sure there are no duplicats. Maybe your mailer is messed up. Just suggestions ;-)

--beau

[Anon]

Instead of "mail()" try "print" to see just what your program is doing.