I am using the following code to send mails (the emails are stored in the database).
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@test.com then the second mail has to recipients as mail1@test.com and mail2@tset.com then the third recipient gets cc as mail1@test.com, mail2@tset.com and mail3@test.com and so on... and the loop continues ... what to do
Code: Select all
$subject="Your friend sends you an interesting link";
$message="Greetings,
Your friend wants you to check the following link:
http://test.com";
$mail->FromName = "Test";
$mail->From = "test@abc.com";
$mail->AddReplyTo("test@abc.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.';
}
}