Re: mailing lists/bulk email sending

From: Date: Thu, 07 Dec 2000 12:32:12 +0000
Subject: Re: mailing lists/bulk email sending
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-29115@lists.php.net to get a copy of this message
Anywho I have a web-based front end to a mailing list; as the list grows, it is no longer feasible to include everyone in one Bcc. For those of you who have done this, what did you use that worked well?
Easy! MySQL: uid name email 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!

« previous php.general (#29115) next »