adjunto el codigo por si estoy errando en algo:
Código PHP:
require("class.phpmailer.php");
$mail = new PHPMailer();
//$mail->Host = "smtp1.example.com";
$mail->From = "[email protected]";
$mail->FromName = "dominio";
$mail->Subject = "Boletin nº452012 dominio";
mysql_connect("localhost", "root", "123456");
mysql_select_db("bbdd_");
$result = mysql_query("SELECT id,mail,enviado FROM boletin_pru WHERE enviado=0 LIMIT 100");
while ($row = mysql_fetch_array($result)) {
// HTML body
$body = "Hola ".$row["mail"].", ";
$body.= "Les comunicamos el nuevo servicio... ";
$body.= "List manager";
// Text body
$text = "Hola ".$row["mail"].", ";
$text.= "Les comunicamos el nuevo servicio...";
$text.= "List manager";
// Configurar Email
$mail->Body = $body;
$mail->AltBody = $text;
$mail->AddAddress($row["mail"], "");
// Enviar el email
if(!$mail->Send()) {
echo "Error al enviar a: " . $row["mail"] . "<br>";
}
$mail->ClearAddresses();
$sql = mysql_query("UPDATE boletin_pru SET enviado='1' WHERE id='".$row["id"]."' ");
}