MAIL database help!

[michaelowen]

hello everybody....i feel like such an idiot that i can't get this right, but basically i am just wanting to loop through the table LOGIN and send each "email_login" field this templated database.

I have about 1500 records in the database and it keeps timing out.....and i have no idea how far it gets...

help!

---

<?php

$db = mysql_connect("localhost", ".....", "......");

mysql_select_db(".......",$db);

$query = mysql_query("SELECT * from login");

$num = mysql_num_rows($query);
for ($i=0; $i<$num; $i++) {
$a = mysql_fetch_array($query);
$to = $a["email_login"];
$from = "management@......com";
$subject = "subject";
$mailheaders = "From: $from\n";
$mailheaders .= "Reply-To: $from\n\n";
$body = "Hello everybody,\n

MESSAGE

";
stripslashes($body);
strip_tags($body);
stripslashes($subject);
strip_tags($subject);
stripslashes($mailheaders);
strip_tags($mailheaders);
mail("$to", "$subject", "$body", "$mailheaders");
echo "sending to ".$to."";
sleep(1);
}
echo "all your emails were sent";

?>

should i use a foreach loop? how can i run this from command line so it doesn't time out?

-Michael

[rachel2004]

Michael, this may not solve your problem, but is intended to help you in troubleshooting. In this area:

mail("$to", "$subject", "$body", "$mailheaders");
    echo "sending to ".$to."";
    sleep(1);
}

change it to this:

mail($to, $subject, $body, $mailheaders);
    echo "sending to ".$to;
    sleep(1);
    echo $i."<br />";
}

I got rid of your quotes around your variables in the mail() function. I also inserted this. Notice that I am also including an echo statement so you can see on the screen how far it is getting into your 1500 records before it "times out" if that is what is actually happening.

I would make your personal e-mail address the first record that it loops through to determine that you are able to even send a message.

hth.

[planetsim]

To avoid timing out use pagination there are quite a few pagination scripts on this forum. Basically it will limit to example 200 then get the next 200 until you have finished sending them all out.

[michaelowen]

is this what you mean? something like this....

---

for ($i=0; $i<200; $i++) {
$a = mysql_fetch_array($query);
$to = $a["email_login"];
$from = "management@......com";
$subject = "subject";
$mailheaders = "From: $from\n";
$mailheaders .= "Reply-To: $from\n\n";
$body = "Hello everybody,\n

MESSAGE

";
stripslashes($body);
strip_tags($body);
stripslashes($subject);
strip_tags($subject);
stripslashes($mailheaders);
strip_tags($mailheaders);
mail("$to", "$subject", "$body", "$mailheaders");
echo "sending to ".$to."";
sleep(1);
}

for ($i=200; $i<400; $i++) {
$a = mysql_fetch_array($query);
$to = $a["email_login"];
$from = "management@......com";
$subject = "subject";
$mailheaders = "From: $from\n";
$mailheaders .= "Reply-To: $from\n\n";
$body = "Hello everybody,\n

MESSAGE

";
stripslashes($body);
strip_tags($body);
stripslashes($subject);
strip_tags($subject);
stripslashes($mailheaders);
strip_tags($mailheaders);
mail("$to", "$subject", "$body", "$mailheaders");
echo "sending to ".$to."";
sleep(1);
}

etc.....until $i=$num (total line numbers)

what about including this on line 1:

<?php
ini_set('max_execution_time', 0);

thanks!
-Michael