Mail loop problem!

[michaelowen]

hello everybody,

i am looping through my db, and pulling a 3 values per entry and then sending them a dynamic email.

My problem is that I want to monitor this email by emai...line by line....however the way it is now, it either times out or or it displays all output at the end of the script....

should i change this to a foreach loop?

---

$query = mysql_query("SELECT * from test");
$from = "[e-mail]";
$subject = "subject";
$body = "$fname $lname,\n
Your bib number is $bib\n";
stripslashes($body);
strip_tags($body);
stripslashes($subject);
strip_tags($subject);
stripslashes($mailheaders);
strip_tags($mailheaders);

while ($row = mysql_fetch_array($query))
{
$email = $row['email'];
$fname = $row['fname'];
$lname = $row['lname'];
$bib = $row['bib'];
mail($email, $subject, $body, $mailheaders);
echo "sending to ".$email."\n";
sleep(5);
ini_set('max_execution_time', '1000');
set_time_limit (1000);

}

thanks!

-Michael

[zhabala]

Should look like this. See the flush() and different position for ini_set.

Zdenek

$query = mysql_query("SELECT * from test"); 
$from = "[e-mail]"; 
$subject = "subject"; 
$body = "$fname $lname,\n 
Your bib number is $bib\n"; 
stripslashes($body); 
strip_tags($body); 
stripslashes($subject); 
strip_tags($subject); 
stripslashes($mailheaders); 
strip_tags($mailheaders); 

ini_set('max_execution_time', '1000'); 
set_time_limit (1000); 

while ($row = mysql_fetch_array($query)) 
{ 
    $email = $row['email']; 
    $fname = $row['fname']; 
    $lname = $row['lname']; 
    $bib = $row['bib']; 
    mail($email, $subject, $body, $mailheaders); 
    echo "sending to ".$email."\n"; 
    flush();
    sleep(5); 
} 

[michaelowen]

here is my latest idea...i think i will write each email to a text file so that if i reach a timeout i will have a log of where i was when it quit.

does this make sense? efficient?

ini_set('max_execution_time', '1000');
set_time_limit (1000);

while ($row = mysql_fetch_array($query))
{
$email = $row['email'];
$fname = $row['fname'];
$lname = $row['lname'];
$bib = $row['bib'];
$from = "[e-mail]";
$subject = "subject";
$mailheaders = "From: $from\n";
$mailheaders .= "Reply-To: $from\n\n";
$body = "$fname $lname,\n
Your bib number is $bib\n";
stripslashes($body);
strip_tags($body);
stripslashes($subject);
strip_tags($subject);
stripslashes($mailheaders);
strip_tags($mailheaders);
mail($email, $subject, $body, $mailheaders);
   $fp = fopen("log.txt","a");
   $content = "sent to ".$email."\r\n";
   fwrite($fp,$content);
   fclose($fp);
    sleep(3);
}
echo "done";

will this write to the file as it goes along, or will it wait (similar to my echo problems) and write it at competion?

-mike