DedMorozzz, выбираю данные из
базы и отправляю письма. Вот часть кода:
<?php
$i = 0;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf("Mail: %s Subject: %s Letter: %s<br />", $row[0], $row[1], $row[2]);
$mess= "{$row[2]}";
$subject="=?UTF-8?B?".base64_encode($row[1])."?=\r\n";
$headers = "From: support@mysite.net\r\n"
. "Content-Type: text/plain; charset=UTF-8 \r\n"
. "MIME-Version: 1.0\r\n"
. "Content-Transfer-Encoding: 8bit \r\n";
$condition = mail($row[0], $subject,$mess, $headers);
if ($condition) {
echo "Letter was sent successfully";
mysql_query("UPDATE mails SET status = 1 WHERE senddate <= ".$today." and id =".$row[3].";") or print mysql_error()."<br>";
$i++;
}
else {
echo "Send error";
}
}
?>