Code: Select all
mysql_select_db($database_conntest, $conntest);
$query_rsa = "SELECT * FROM Items WHERE SDate= CURDATE() - Interval 1 Day";
$rsa = mysql_query($query_rsa, $conntest) or die(mysql_error());
$row_rsa = mysql_fetch_assoc($rsa);
$totalRows_rsa= mysql_num_rows($rsa);
?>
<?php
$headers = "From: House@Example.com <house@example.com>\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-type: text/html; charset=UTF-8";
$subject = "Example Subject";
$headerPic = "<IMG src='http://example,com/photos/$row_rsa[Image_URL]' width='198' class='imgfloatlft' align='left' hspace='10'>";
$body = "<html><body>" .
"<h2><center>Heading</center></h2>" .
"<p>TEXT</p>" .
"<p>$headerPic</p>" .
"<p>TEXT</p>" .
"</body></html>";
mysql_select_db($database_conntest, $conntest);
$result = mysql_query("SELECT Email1, Email2, Email3 FROM Items WHERE SDate=CURDATE() - Interval 1 Day");
if(mysql_num_rows($result) > 0)
{
$count = 0;
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))
{
$to = $row['Email1'] . ', ';
$to .= $row['Email2'] . ', ';
$to .= $row['Email3'];
mail($to, $subject, $body, $headers);
$count++;
}
echo "myResult=$count Emails Sent.";
}
else
{
echo "myResult=Email Submissions Failed.";
}
?>