PHP send mass email using MySQL info

Anon

It looks like someone here could create a simple script like what I'm looking for. I need a PHP script that will take info from a MySQL db (like email addr, name, etc...) and send an email to all the entries of the db. This is for an alumni page for a high school that needs to let all their alumni (who are entered into a db) know that the new site is up and include their info that they've submitted. Thanks.

[deleted]

It does say "Search before you post" doesn't it? so why didn't you hmm? 🙂

Anon

I did search for it, but all I came up with was one post that was relevant:

http://www.phpbuilder.com/forum/read.php3?num=2&id=118907&loc=0&thread=118907

Yet he had a problem with his script and no one replied, so I'm assuming it's not fully functional. Since you've obviously found a better post that fixes my problem, please let me know.

Anon

This is a basic idea

$conn=mysql_connect("localhost", "user", "pasword);
$db=mysql_select_db("your database", $conn);

$sql="SELECT email FROM your_table";
$result=mysql_query($sql, $conn);

while($res=mysql_fetch_array($result))
{
mail("$res["email"]", $subject, $message);
}

That's it. Make sure that you have mail aggent such as qmail or sendmail setup, otherwise it won't send.

If you want to setup small mailing list, than check this link:
http://www.thickbook.com/extra/php_sublist.phtml