Do it just like you would with prev/next links. Use LIMIT in your query to
get out 50 or so at a time. Loop through them, sending mail, then use header
to automatically redirect to the next page, incrementing the number to use
----- Original Message -----
From: "Justin French" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 7:44 AM
Subject: [PHP] bulk mail()
> Hi all,
> I've got a mailing on a website, with email address' / names / etc in a
> MySQL table.
> I think there's around 120 on it at the moment.
> I've been noticing a growing lag on the sending of mail though... I've got
> script which takes a message from a form, then runs a while loop through
> rows of the mailing_list table, replacing a special string with the
> subscribers name, and sending using the mail() command.
> However, this time, the script actually failed, with a "failure when
> attempting to access blah.com/foo.php" (the sending script). I have no
> if SOME people got the email, or what, and have no idea how to check.
> So, I make the assumption that as the mailing list has grown, the script
> time has slowed... now it's too big (or the server was too busy) to
> all the emails before the script timed out.
> If I didn't want to personalise the emails, I'm sure the script would run
> lot quicker with every address in the Bcc header, but since we personalise
> each email, I can't see any option other than using mail() 200 times...
> it's only going to get a lot worse as we climb to 1000+.
> So, what options do I have?
> Break the mailing list up into batches of 40 or so? How would I implement
> something like this?
> Any advice / concepts / ideas welcome!
> Justin French
> Creative Director
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php