Can anyone tell me why this doesn't seem to send out emails? It returns the appropriate echo but doesn't submit emails. Here's the code. Thanks!
<?php session_start();
// check session variable
if (!isset($HTTP_SESSION_VARS['valid_user']))
{
?>
<?include("header.php");?><hr width="70%" /><br />
You are not logged in.<br /><br />
<a href="index.php" class="roll">Log in</a>
<?php
}
if (isset($HTTP_SESSION_VARS['valid_user']))
{
?>
<?include("header.php");?>
<?php
if (!$HTTP_SESSION_VARS['valid_user'] == Administrator)
{
'<p><center>You do not have administrator privileges.<br /><br />
<a href="logout.php" class="roll">Log Out</a></center></p>';
}
if ($HTTP_SESSION_VARS['valid_user'] == Administrator)
{
?>
<?include("adminnavemail.php");?>
<h3>Email Agencies</h3>
<form method="post" action="<?php echo $PHP_SELF; ?>">
<?php
if (!$submit)
{
?>
This function will email all agencies their reports.<br /><br />
<input type=submit name="submit" value="Email" class="button">
<?php
}
if ($submit)
{
$db = @mysql_connect('localhost', 'user, 'pass');
mysql_select_db('esbsolu_powerbucks');
$toquery="SELECT * FROM email WHERE AgencyID='Harris'";
$toresult= mysql_query($toquery) or die(mysql_error());
while($r = mysql_fetch_array($toresult))
{
$AgencyID=$r["AgencyID"];
$MD=$r["MD"];
$Email=$r["Email"];
mysql_select_db('esbsolu_powerbucks');
$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID='$AgencyID'";
$HoursSumResult=mysql_query($HoursSum) or die(mysql_error());
$TotalHours= mysql_result($HoursSumResult,0) or die(mysql_error());
mysql_select_db('esbsolu_powerbucks');
$theQuery = "SELECT * FROM listings WHERE id='$AgencyID'";
$agencyquery= mysql_query($theQuery) or die(mysql_error());
while($r = mysql_fetch_array($agencyquery))
{
$id=$r["id"];
$agency=$r["agency"];
$budget=$r["budget"];
$Balance= $budget - (100*$TotalHours);
mysql_select_db('esbsolu_powerbucks');
$JobNumHoursSum = "SELECT JobNum, Project, AgencyID, SUM(Hours) from transactions GROUP BY JobNum HAVING AgencyID='$AgencyID' ORDER BY JobNum ASC";
$transactions=mysql_query($JobNumHoursSum) or die(mysql_error());
while($r = mysql_fetch_array($transactions))
{
$JobNum=$r["JobNum"];
$Project=$r["Project"];
$AgencyID=$r["AgencyID"];
$Hours=$r["SUM(Hours)"];
$Powerbucks=100*$Hours;
$message="<html><head></head><body>
<h3>Agency Report: $agency</h3>
<p><center><br /><h5>TRANSACTIONS:</h5>
<table border='0' width='500' cellspacing='0' cellpadding='0'><tr><td align='left' width='167' class='starting'>Starting Balance</td><td align='right' width='333' colspan='2' class='starting'><b>$$budget</b></td></tr><tr><td class='top' colspan='3'> </td></tr><tr><td align='left' class='top'><b>Job Number</b></td><td align='left' class='top'><b>Project</b></td><td align='right' class='top'><b>Amount</b></td></tr><tr><td align='left'>$JobNum</td><td align='left'>$Project</td><td align='right'>$$Powerbucks</td></tr><tr><td class='top' colspan='3'> </td></tr><tr><td align='left' width='167' class='remaining'>Remaining Balance</td><td align='right' width='333' colspan='2' class='remaining'><b>$$Balance</b></td></tr></table><br /><a href='http://www.esbsolutions.com/project/powerbucks/index.php'>View your full report</a></center></p></body></html>";
$subject = "Please view your agency report";
$x = 1;
$hold = 50;
// quantity of emails sent before 3 sec delay
$emails = mysql_query("SELECT * FROM email");
while ($sendemail = mysql_fetch_array($emails))
{
$email = $sendemail["Email"];
mail($email, $subject,
$message, "From:PowerBucks <mail@esbsolutions.com>");
$x++;
if($x == $hold)
{
// When $x is equal to $hold, a 3 sec delay will occur avoiding php to timeout
sleep(3);
$x = 0;
}
}
}
}
}
echo 'All agencies have been emailed.';
mysql_close($db);
}
?>
</form>
<?php
}
}
?>
<?include("footer.php");?>
