RE: [PHP] How Can I Generate an Email List from a MySQL Table
On Sat, 17 Aug 2002 20:10:02 -0700
Roger Lewis [EMAIL PROTECTED] wrote:
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.
Daren Cotter [mailto:[EMAIL PROTECTED]] responded
Saturday, August 17, 2002 8:42 PM
// Query database
$result = mysql_query(SELECT email_address FROM users
WHERE is_subscribed = 'Y', $link);
while ($row = mysql_fetch_array($result)) {
mail($row[email_address], $SUBJECT, $BODY,
$HEADER);
}
mysql_free_result($result);
Darren,
Thanks a lot. This works fine. Please have a virtual beer on me! :)
To Chris Knipe [mailto:[EMAIL PROTECTED]] who responded
$to = '';
while ($blah = mysql_fetch_row($ref)) {
$to =+ $blah['address'];
};
I tried this, but I got an index error. It doesn't understand 'address'
and I couldn't figure out what was going on.
To Kevin Waterson who responded
simply create your array and use implode.
There is an example of comma seperated lists in the manual
http://www.php.net/manual/en/function.implode.php
I like this method because it seems more elegant than above, but I don't
seem to be able to create the array properly.
I tried the following as well as many other combinations, but couldn't get
anything to work:
$sql = SELECT email_address FROM users WHERE is_subscribed = 1;
$result = mysql_query($sql);
$to = implode(,, mysql_fetch_array($result));
Thanks again everyone for your help
Roger Lewis
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
RE: [PHP] How Can I Generate an Email List from a MySQL Table
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
Re: [PHP] How Can I Generate an Email List from a MySQL Table
on 18/08/02 2:20 PM, Roger Lewis ([EMAIL PROTECTED]) wrote: Thanks for the quick responses from Chris, Daren, and Kevin. I didn't know so many would be up Sat night. It's not Saturday night everywhere :) Justin French -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
