Re: mailing lists/bulk email sending
| From: | Paul Schreiber | Date: | Thu, 07 Dec 2000 14:58:31 +0000 |
| Subject: | Re: mailing lists/bulk email sending | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-29139@lists.php.net to get a copy of this message | ||
Derek Sivers wrote:
>Query("select * from customers group by email");
>
>while ($customers = $db->next_record())
> {
> $subject = "Hi $customers[name]";
> $body = "$customers[name] -
> You look lovely today.";
>
> mail ($customers[email], etc.);
>
> print "Emailed $customers[name]";
> flush();
> }
>
>Then just make a simple MySQL maintenance thing, or use phpMyAdmin to
>administer your list in MySQL!
You *really* don't want to mail 1000 people one at a time. That will time
out (plus it's a horridly inefficient algorithm).
Paul
shad 96c / 4A CS / mac activist / eda / fumbler
fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner /
/ x-files / buffy / dawson's creek / habs / bills / 49ers /
t h i n k d i f f e r e n t.
"It's like signing a record contract is like signing away your
human rights." -- CMG