<b>Last 180 Days</b>
<form ..>
<select name="agent" onchange="this.form.submit();">
<option value="">Select</option>
<option value="All">All</option>
<?php $agents = file('../agents.txt');
			foreach($agents as $line){

				echo '<option value=\'';
				echo $line;
				echo '\'>';
				echo $line;
				echo '</option>';
			}
		?></select>

</form>

<table id="form">

<?php
$val = $_GET['agent'];
$val2 = trim($val);
$con = mysql_connect("localhost","root","lolerskates");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("rta", $con);
$result = NULL;
$result2 = NULL;

if($val2==="" || $val2==="All")
{
$result = mysql_query("SELECT * FROM attendance where date > DATE_SUB(CURDATE(), INTERVAL 180 DAY)");
$result2 = mysql_query("SELECT * FROM attendance where date > DATE_SUB(CURDATE(), INTERVAL 365 DAY)");
} else
{
$result = mysql_query("SELECT * FROM attendance where agent = '$val2' AND date > DATE_SUB(CURDATE(), INTERVAL 180 DAY)");
$result2 = mysql_query("SELECT * FROM attendance where agent = '$val2' AND date > DATE_SUB(CURDATE(), INTERVAL 365 DAY)");
}


echo "<table border=1>";
echo "<th>Name</th>";
echo "<th>Date</th>";
echo "<th>Start</th>";
echo "<th>Stop</th>";
echo "<th>All Day</th>";
echo "<th>Count</th>";
echo "<th>Comment</th>";
echo "<th>Action Taken</th>";
echo "<th>Time Inserted</th>";
echo "<th>Submitter</th>";
$total = 0;
$total365 = 0;
while($row = mysql_fetch_array($result))
{
$total += $row['auxcode'];
?>
<tr>
<td> <?php echo $row['agent'] ?> </td>
<td> <?php echo $row['date'] ?> </td>
<td> <?php echo $row['time2'] ?> </td>
<td> <?php echo $row['time3'] ?> </td>
<td> <?php echo $row['AllDay'] ?> </td>
<td> <?php echo $row['auxcode'] ?> </td>
<td width="350px"> <?php echo $row['comments'] ?> </td>
<td> <?php echo $row['action'] ?> </td>
<td width="150px"> <?php echo $row['timeinserted'] ?> </td>
<td> <?php echo $row['username'] ?> </td>
</tr>
<?php
}
?>
</table>
<?php
echo "<br><b>Total Occurrence Count (180 days): $total</b><br>";
while($row = mysql_fetch_array($result2))
{
$total365 += $row['auxcode'];
}
echo "<b>Total Occurrence Count (365 days): $total365</b><br><br><table border='2' bgcolor='#E6E1E2'><th>Full Occurrence = 1, Tardy = 0.5</th><br><tr><td>Total of 3 - Coaching</td></tr><tr><td>Total of 4 - Documented Counseling</td></tr><tr><td>Total of 5 - Written</td></tr><tr><td>Total of 6 - Final</td></tr><tr><td> Total of 7 - Possible Termination</td></tr></table>";
mysql_close($con);
?>
</table>
</form>