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 in LIMIT.
---John Holmes... ----- 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 a > script which takes a message from a form, then runs a while loop through the > 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 idea > 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 process > all the emails before the script timed out. > > > If I didn't want to personalise the emails, I'm sure the script would run a > 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... and > 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 > http://Indent.com.au > -------------------- > > > -- > 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
