For some reason I'm unable to pass the selectedagency variable to the second section (the if ($comment) section) so that it can re-display the same page....once I activate the comment button, it jumps to the
!$num_results section because the selectedagency variable has not passed. Any suggestions?
Thanks!
$selectedagency=$HTTP_POST_VARS['selectedagency'];
if($submit)
{
$selectedagency=$HTTP_POST_VARS['selectedagency'];
if ($selectedagency=='0')
{
include("db.php3");
include("dbselect.php3");
echo '<h3>Agency Reports</h3>You have not selected an agency!<br /><br />Please select an agency in order to view their PowerBucks Report.<br /><br />';
// populate the drop down menu
$namepull = "SELECT * FROM listings ORDER BY agency ASC";
// execute SQL query and get result
$nameput = mysql_query($namepull) or die(mysql_error());
// put data into drop-down list box
while ($r = mysql_fetch_array($nameput))
{
$agency=$r["agency"];
$agencies .= "<option value=\"$agency\">$agency";
}
?>
<select name="selectedagency" id="agency" size="1" style="background-color:#F7F7F7;">
<? echo "<option value=\"0\" selected>Select Agency Report";?>
<? echo "$agencies"; ?>
</select>
<input type="submit" name="submit" value="Submit" class="button">
<?php
exit;
}
else
{
if ($comment)
{
$selectedagency = $HTTP_POST_VARS['selectedagency'];
$message = $HTTP_POST_VARS['message'];
$recipient = "cybersounds@yahoo.com";
$subject = "Message from $agency via transaction page";
@mail($recipient, $subject, $message, "From:PowerBucks <powerworks@trinitynet.com>");
include("db.php3");
include("dbselect.php3");
$date=date('F j, Y');
$theQuery = "SELECT * FROM listings WHERE agency='$selectedagency'";
$agencyquery= mysql_query($theQuery) or die(mysql_error());
while($r = mysql_fetch_array($agencyquery))
{
$id=$r["id"];
$agency=$r["agency"];
$budget=$r["budget"];
include("dbselect.php3");
$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID='$id'";
$HoursSumResult=mysql_query($HoursSum);
$TotalHours= mysql_result($HoursSumResult,0);
$Balance= $budget - (100*$TotalHours);
include("dbselect.php3");
$JobNumHoursSum = "SELECT JobNum, Project, AgencyID, SUM(Hours) from transactions WHERE AgencyID='$id' GROUP BY JobNum";
$transactions=mysql_query($JobNumHoursSum);
$num_results = mysql_num_rows($transactions);
}
if (!$num_results)
{
echo '<h3>Agency Report: '.$agency .'</h3><p> <center><br /><h5>TRANSACTIONS as of '.$date.':</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" class="starting"><b>$'.$budget.'</b></td></tr><tr><td class="top" colspan="2"><br /><br /><i>No transactions have been inputted</i><br /><br /><br /></td></tr><tr><td align="left" width="167" class="remaining">Remaining Balance</td><td align="right" width="333" class="remaining"><b>$'.$Balance.'</b></td></tr></table><br /><a href="admin.php3" class="roll">Go back</a></center></p>';
exit;
}
if ($num_results)
{
echo '<h3>Agency Report: '.$agency .'</h3><p><center><br /><h5>TRANSACTIONS as of '.$date.':</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>YTD</b></td></tr>';
while($r = mysql_fetch_array($transactions))
{
$JobNum=$r["JobNum"];
$Project=$r["Project"];
$AgencyID=$r["AgencyID"];
$Hours=$r["SUM(Hours)"];
$Powerbucks=100*$Hours;
echo '<tr><td align="left">'.$JobNum.'</td><td align="left">'.$Project.'</td><td align="right">$'.$Powerbucks.'</td></tr>';
}
echo '<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 /><br />Your message has been posted.<a href="admin.php3" class="roll">Go back</a>';
}
}
if (!$comment)
{
include("db.php3");
include("dbselect.php3");
$date=date('F j, Y');
$theQuery = "SELECT * FROM listings WHERE agency='$selectedagency'";
$agencyquery= mysql_query($theQuery) or die(mysql_error());
while($r = mysql_fetch_array($agencyquery))
{
$id=$r["id"];
$agency=$r["agency"];
$budget=$r["budget"];
include("dbselect.php3");
$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID='$id'";
$HoursSumResult=mysql_query($HoursSum);
$TotalHours= mysql_result($HoursSumResult,0);
$Balance= $budget - (100*$TotalHours);
include("dbselect.php3");
$JobNumHoursSum = "SELECT JobNum, Project, AgencyID, SUM(Hours) from transactions WHERE AgencyID='$id' GROUP BY JobNum";
$transactions=mysql_query($JobNumHoursSum);
$num_results = mysql_num_rows($transactions);
}
if (!$num_results)
{
echo '<h3>Agency Report: '.$agency .'</h3><p> <center><br /><h5>TRANSACTIONS as of '.$date.':</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" class="starting"><b>$'.$budget.'</b></td></tr><tr><td class="top" colspan="2"><br /><br /><i>No transactions have been inputted</i><br /><br /><br /></td></tr><tr><td align="left" width="167" class="remaining">Remaining Balance</td><td align="right" width="333" class="remaining"><b>$'.$Balance.'</b></td></tr></table><br /><a href="admin.php3" class="roll">Go back</a></center></p>';
exit;
}
if ($num_results)
{
echo '<h3>Agency Report: '.$agency .'</h3><p><center><br /><h5>TRANSACTIONS as of '.$date.':</h5><table border="0" width="500" cellspacing="0" cellpadding="0" valign="top"><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>YTD</b></td></tr>';
while($r = mysql_fetch_array($transactions))
{
$JobNum=$r["JobNum"];
$Project=$r["Project"];
$AgencyID=$r["AgencyID"];
$Hours=$r["SUM(Hours)"];
$Powerbucks=100*$Hours;
echo '<tr><td align="left">'.$JobNum.'</td><td align="left">'.$Project.'</td><td align="right">$'.$Powerbucks.'</td></tr>';
}
echo '<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><tr><td colspan="3" valign="top"><br />Post a comment or <a href="admin.php3" class="roll">go back.</a><br /><textarea wrap name="message" rows="2" cols="50"></textarea><br /><input type="hidden" name="submit" value="Submit"><input type="submit" name="comment" value="Submit" class="button"></td></tr></table>';
}
}
}
}
