Thanks for the quick responses from Chris, Daren, and Kevin. I didn't know so many would be up Sat night. This looks like it might do the trick since I only have 20 to 30 recipients and I have a dedicated server. I'll check it out and let you know. Thanks again, Roger
-----Original Message----- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 17, 2002 8:37 PM To: Roger Lewis; Php-General Subject: Re: [PHP] How Can I Generate an Email List from a MySQL Table $to = ''; while ($blah = mysql_fetch_row($ref)) { $to =+ $blah['address']; }; Be careful however. Most SMTP servers has a limit on the number of recipients you can send one email to. It's a very easy way to trigger spam alerts and stuff. -- me ----- Original Message ----- From: "Roger Lewis" <[EMAIL PROTECTED]> To: "Php-General" <[EMAIL PROTECTED]> Sent: Sunday, August 18, 2002 5:10 AM Subject: [PHP] How Can I Generate an Email List from a MySQL Table > I have a MySQL table named "users" in which there is a column named > "email_address" and another named "is_subscribed". I would like to send an > email to all of the addresses for which "is_subscribed" is true. I think I > know how to send the email, i.e., > > mail($to, $subject, $message, $headers); > > I tested this out and it works fine when, for instance, $to = > "[EMAIL PROTECTED], [EMAIL PROTECTED]" or some such collection of > addresses. > > My problem is how do you create the variable, $to, from the MySQL table so > that it contains all of the addresses separated by commas. > > Thanks for your help, > > Roger Lewis > > > -- > 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
