I need help with my mailing list script

[akrocks_extreme]

i'm working on a mailing list script.. i have it so you can customize the email, and it automatically puts everyones names in it so you dont have to write a new email for everyone on your list.. it all works except sending it.. how can i send more than one message at a time?

Here are the bare bones...

$subject = $_POST['subject'];
$message = $_POST['message'];
$fromfriendly = $_POST['fromaddress'];
$tofriendly = $_POST['tofriend'];

if ($subject && $message)
{

 $result=mysql_query("SELECT * FROM affiliates", $connection);  //Selects all entries from table users
 while($query_data = mysql_fetch_row($result))  //Selects the first row of returned results
  {
        $to = $query_data[9];
        $emcode = array("[realname]", "[id]", "[password]", "[email]");
$emreal = array($query_data[8], $query_data[0], $query_data[1], $query_data[9]);
$newmessage = str_replace($emcode, $emreal, $message);
$newsubject = str_replace($emcode, $emreal, $subject);
$newtofriendly = str_replace($emcode, $emreal, $tofriendly);
$newfromfriendly = str_replace($emcode, $emreal, $fromfriendly);

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

/* additional headers */
$headers .= "To: $newtofriendly\r\n";
$headers .= "From: $newfromfriendly\r\n";
echo ("<br><b>To:</b> $newtofriendly<br><b>From:</b> $newfromfriendly <br><b>Subject:</b> $newsubject <br><b>Message:</b> $newmessage"); //for debugging only
if (mail($to, $newsubject, $newmessage, $headers))
{
echo ("Message Successfully Sent.");
}
else
{
echo ("Message Was Not Sent.");
}
}
}

The first person in line gets an email sent to them but the others fail... are there any "massmail" functions? or a better way to do this? thanks.

---

Ok, problem solved! thanks guys!

[bastien]

if you where to echo out the vairable $to before sending the email, does it show what you expect?

I get the feeling that there may only be one name in there

as for mass mailers...phpmailer is a great class for this type of thing

let me know about the number of names in the emails $to section...

[siefkencp]

I used the same sort of script, i used an array and a do while loop to get multiple e-mails out at once... this can blow through spam catchers too because the e-mail is only being sent to one person at a time... Every time it loops it sends out another e-mail.

Below is an example of that code...

<?php

// you can make this array an sql query too, however it works best if you limit your out flow to 250 at a time.

$address_array = explode(";" , $address);

$headers = "From: blah <[e-mail]> \n";
$headers .= "Content-type: text/html";
$msg .= "<br><center> To be removed from our mailing list please reply with a blank e-mail to this message.</center>";

foreach ($address_array as $key => $value){
mail($address_array[$key], $sub, $msg , $headers);
}

print "Success!"
?>

Chris