PHP and MySQL ? Creating a mailing list

[Saint Nick]

Hey everyone... I added a feature to my band's Wordpress website/blog where users can subscribe to our mailing list. So we have people subscribe and their e-mail is stored in the database ... now, how can I write a PHP script or page that allows me to send a newsletter to all of the e-mails stored in that table?

 

[Ken g6]

How do you plan to send the mail? Do you have access to sendmail or some such low-level program from PHP? Maybe you just want a page that returns the list of emails, so you can copy/paste them into the Bcc field of your favorite mail program?

 

[Superwormy]

You could always use something pre-built:
http://phpmailer.codeworxtech....dex.php?pg=phpmailerml
http://pommo.org/Main_Page

Otherwise, you're asking a pretty general question. In short, if the e-mail addresses are in a database, something like:
$res = mysql_query("SELECT email FROM your_table");
while ($arr = mysql_fetch_assoc($res))
{
$email = $arr['email'];
mail($email, 'subject goes here', 'message goes here');
}