phpmailer and multiple recievers?!?!

[jmansa]

I'm trying to set up a script which send a mail pr. reciever in a loop like this:

require_once("emails/themail.php");

foreach($currUserids as $currUserid){

$sql="SELECT * FROM ".$prefix."_users WHERE new_userid = '$currUserid'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

$reEmail = $row['email'];
$reFname = $row['fname'];
$reLname = $row['lname'];

////////////// SEND MAIL START ////////////////

themail();

///////////// SEND MAIL END ///////////////

} 

themail.php:

$mail = new PHPMailer();

$mail->IsSendmail(); // telling the class to use SendMail transport

$mail->From       = '[e-mail]';
$mail->FromName   = 'Me';

$mail->AddAddress($memail, $mfname.' '.$mlname);

$mail->Subject    = "".$cfname." ".$clname." wrote an email to you"; 

////////// START EMAIL //////////

/* The email contenet here */

$body = $textHTML;

////////// END EMAIL //////////

$body = eregi_replace("[\]",'',$body);

$mail->MsgHTML($body);

if(!$mail->Send()) {
  echo "Mailer Error: " . $mail->ErrorInfo;
} else {
  //echo "Message sent!";
}

Now, everything works fine when sending to one reciever, but when I want to send to multiple recievers they each recieves duplicate mails for the number of recivers... How do I get passed this???

Please help... Thanks

[NogDog]

Not quite sure: do you want to send one email out with multiple recipients, or do you want to send a separate email to each (a single recipient per email)?

[Atli]

Hey.

If you want to send them all the same message, try something like:

// Query for all the user info
$sql = "SELECT email, fname, lname 
        FROM {$prefix}_users 
        WHERE new_userid IN(". implode(",", $currUserids) .")";
$result = mysql_query($sql) or trigger_error(mysql_error(), E_USER_ERROR);

// Add each user to the PHPMailer object.
while($row = mysql_fetch_assoc($result)
{
    $name = $row['lname'] .", ". $row['fname'];
    $mailer->AddAddress($row['email'], $name);
}