PHP Mail Script

Pull addresses from MYSQL

[piskie]

I need a reasonably secure php mail script that will select the appropriate Email Address from a MYSQL Table.

Has anybody got any suggestions or recommendations please

[barns101]

This simple code will do it:

<?php
// Define the text of your email
$message = 'Your email body text.';
// Connect to your database, grab the email addresses and send the message
mysql_connect('localhost','user','pass');
mysql_select_db('database');
$result = mysql_query ("SELECT * FROM `table`");
while ($row = mysql_fetch_array($result))
{
// Assuming that there is a field named "email" in your table
mail($row[email], 'Subject', $message, 'From: You <[e-mail]>');
}
?>