You'll need to be careful with this method. In an effort to keep spam to a minimum, some ISP's may refuse messages with more than X number of email address attached. Then the question becomes: did everyone on the list actually receive the message?
-----Original Message----- From: Justin French <[EMAIL PROTECTED]> To: Stephen <[EMAIL PROTECTED]>; PHP List <[EMAIL PROTECTED]> Date: Friday, October 25, 2002 7:53 PM Subject: Re: [PHP] One mail function, multiple recipients >instead of your while() loop calling mail() each time, use it to build a >comma separated list of recipients, then pipe them into a Bcc (so as to not >publicise everyone's email address), and send one email with all people in >the Bcc list. > >UNTESTED code: ><? >$bcc = ''; > >$sql = "SELECT email FROM mailingListTable"; >$result = mysql_query($sql); > >while($myrow = mysql_fetch_array($result)) > { > $bcc .= $myrow['email'].','; > } > >// $bcc will now look like: >// [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED], > >// trim off the trailing comma >$bcc = substr($bcc, 0, -1); > >// prepare to send >$to = '[EMAIL PROTECTED]'; >$subject = 'My Mailing List'; >$message = 'This is my email message'; >$headers = 'From: [EMAIL PROTECTED]\r\n'; >$headers .= "Bcc: {$bcc}\r\n"; > >// send >mail($to, $subject, $message, $headers); >?> > > >Good luck -- like I said, untested code, so it may need some tweaking. > > >Justin > > > >on 26/10/02 10:41 AM, Stephen ([EMAIL PROTECTED]) wrote: > >> I'm pulling email addresses from a database, then emailing them a newsletter >> email. Right now, I'm calling the mail() function each time to send an email >> and that's slooow. How could I make it so all the emails are put into a BCC >> field then emailed all at once instead of multiple times? >> >> Thanks, >> Stephen Craton >> http://www.melchior.us >> http://php.melchior.us > > >-- >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