Forum Moderators: coopster
The problem is If there are 5 mails in the database then the following code sends 5 emails to each of the 5 emails... i mean mail1@example.com then the second mail has to recipients as mail1@example.com and mail2@example.com then the third recipient gets cc as mail1@example.com, mail2@example.com and mail3@example.com and so on... and the loop continues ... what to do
$subject="Your friend sends you an interesting link";
$message="Greetings,Your friend wants you to check the following link:
http://example.com";
$mail->FromName = "Test";
$mail->From = "test@example2.com";
$mail->AddReplyTo("test@example2.com", "Test");
$mail->Subject = $subject;
$mail->Body = $message;
$mail->WordWrap = 65;
$sql = "SELECT * FROM contacts";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$value=$row['email'];
$mail->AddAddress($value);
if(!$mail->Send())
{
echo 'Message was not sent.';
echo 'Mailer error: ' . $mail->ErrorInfo;
}
else
{
echo 'Message has been sent.';
}
}
I want to send the newsletter something like blind carbon copy .
[edited by: eelixduppy at 6:25 am (utc) on Oct. 22, 2007]
[edit reason] changed to example.com [/edit]
}
Outside the while loop
(So you have)
while($row = mysql_fetch_array($result)){
$value=$row['email'];
$mail->AddAddress($value);
}
if(!$mail->Send())
{
echo 'Message was not sent.';
echo 'Mailer error: ' . $mail->ErrorInfo;
}
else
{
echo 'Message has been sent.';
}
