Im looking email members from a database where the emails are stored but also in a seperate table would be the information I want to send to them . I have this code of which i could use manually but

1. how do i get the multiple recipients to go in automatically rather than manually.
2. subject and message of the email from another table

Would be nice if you could help.

// multiple recipients
$to  = '' . ', '; // note the comma
$to .= '';

// subject
$subject = 'Birthday Reminders for August';

// message
$message = '
  <title>Birthday Reminders for August</title>
  <p>Here are the birthdays upcoming in August!</p>

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers
$headers .= 'To: Mary <>, Kelly <>' . "\r\n";
$headers .= 'From: Birthday Reminder <>' . "\r\n";
$headers .= 'Cc:' . "\r\n";
$headers .= 'Bcc:' . "\r\n";

// Mail it
mail($to, $subject, $message, $headers);

In order for the recipients to be generated dynamically, you will need to do a query to fetch the recipients:


$query = mysql_query("SELECT email_address FROM table WHERE date = someonesbirthdate");

// while there are result email addresses, add them to the recipients lists
while ($results = mysql_fetch_assoc($query))
    // multiple recipients array
    $to[]  = $results['email_address'] . ', ';

The same would be required for the subject content. Just query the database and while results exist, put them into the a subject variable or array.