MySql & PHP mail problem

[DasHaas]

Im trying to send emails to all the email addresses in my database table. My table currently has 3 test emails but the script below only send the email to one of the email addresses. What do I need to modify to make it send to all email addresses in the table?

 

    
   $query = mysql_query("SELECT email FROM PXS_Newsletter WHERE verified = 1") or die (mysql_error());
   while($row=mysql_fetch_row($query))
   $email = $row[0];

   $To = $email;
   $Subject = $msgsubject;
   $Body =  $msgbody;
   mail($To, $Subject, $Body);

[chigley]

<?php

$query = mysql_query("SELECT email FROM PXS_Newsletter WHERE verified = 1") or die (mysql_error());

while($row = mysql_fetch_row($query)) {
$email = $row[0];
mail($email, $msgsubject, $msgbody);
echo "Email sent to $email<br />";
}

?>

[DasHaas]

still only sends the email to one recipient. It seems to be sending the email only to the first entry in the database ???

[DasHaas]

pfft it worked it just took a few minutes to send to the second email address. DO you think this lag wil be multiplied once I have 100+ email addresses in the database?

[chigley]

Sounds like your server needs a cleanup, what are you running on?

[Guardian-Mage]

You should look at the PHP Config File

 

My system is similar to yours and sends 100+ emails within 2 minutes

[DasHaas]

Its not my server, I am using a gate.com server that has PHP and MySql installed. I dont think I have access to the config file

[chigley]

I can rattle off about 100 in 30 seconds with almost identical code; so it must be your server!

[DasHaas]

Maybe I will give them a call and see if they can modify the config file, i dont think they will but its worth a try