mail() (Something stranger here)

thoand

hi,
I have this mailinglist where I pull out the mailadress from a database in a loop, my problem is that sometimes the users gets 2-3 mails.

I have 'washed' the database, so there are no dublicate adresses, and on top of that I use "SELECT DISTINCT ..."

And, I am not pushing the send button while executing.

Can anyone tell me why it sometimes it send 2-3 mails at a time?

thanks in advance Thomas

Jayson

We need more info. And we can't tell you what is wrong with your code if we can't see it.

thoand

I think the code is fine, 4 people have looke over it, and everybody says it look ok (even my ISP)

anyway here is the query and the loop

$Q = "SELECT DISTINCT mail from foo WHERE type = 1";

$Result = mysql_db_query("$db", $Q);

while ($adresser = @mysql_fetch_array($Result)){
$to = $adresser['mail'];
mail($to, "$Subjekt", "$html_stuff_start".stripslashes($body)."$html_stuff_end".$footer."", "$headers");
}

regards Thomas

Jayson

I don't see anything that would cause problems there. Maybe the problem is in the mail server?

jpr

I'm not sure if you would want to keep this or not, but just try using this script of mine. It is very easy to fit right to your current table. Just see if this works for what you want to do. It has always worked for me. Very easy, very simple.

http://www.rottmansales.com/jason/public_scripts/jmm v1.1.zip

Jason Rottman

jpr

rottmansales.com/jason/public_scripts/jmm v1.1.zip

thats the link 🙂