";
while ($status = mysqli_fetch_array($result)) {
$sqlJan = "select * from status where statusMonth='January' and statusYear=$year order by statusID";
$resultJan = mysqli_query($conn, $sqlJan);
$sqlFeb = "select * from status where statusMonth='February' and statusYear=$year order by statusID";
$resultFeb = mysqli_query($conn, $sqlFeb);
$sqlMar = "select * from status where statusMonth='March' and statusYear=$year order by statusID";
$resultMar = mysqli_query($conn, $sqlMar);
$sqlApr = "select * from status where statusMonth='April' and statusYear=$year order by statusID";
$resultApr = mysqli_query($conn, $sqlApr);
$sqlMay = "select * from status where statusMonth='May' and statusYear=$year order by statusID";
$resultMay = mysqli_query($conn, $sqlMay);
$sqlJun = "select * from status where statusMonth='June' and statusYear=$year order by statusID";
$resultJun = mysqli_query($conn, $sqlJun);
$sqlJul = "select * from status where statusMonth='July' and statusYear=$year order by statusID";
$resultJul = mysqli_query($conn, $sqlJul);
$sqlAug = "select * from status where statusMonth='August' and statusYear=$year order by statusID";
$resultAug = mysqli_query($conn, $sqlAug);
$sqlSep = "select * from status where statusMonth='September' and statusYear=$year order by statusID";
$resultSep = mysqli_query($conn, $sqlSep);
$sqlOct = "select * from status where statusMonth='October' and statusYear=$year order by statusID";
$resultOct = mysqli_query($conn, $sqlOct);
$sqlNov = "select * from status where statusMonth='November' and statusYear=$year order by statusID";
$resultNov = mysqli_query($conn, $sqlNov);
$sqlDec = "select * from status where statusMonth='December' and statusYear=$year order by statusID";
$resultDec = mysqli_query($conn, $sqlDec);
}
if (mysqli_num_rows($resultJan) >0) {
$month = 1;
print "January";
print "
";
echo "- ";
while ($statusJan = mysqli_fetch_array($resultJan)) {
print "
- ".$statusJan['statusMonth']." ".$statusJan['statusDate'].", ".$statusJan['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultFeb) >0) {
$month++;
print "February";
print "
";
echo "- ";
while ($statusFeb = mysqli_fetch_array($resultFeb)) {
print "
- ".$statusFeb['statusMonth']." ".$statusFeb['statusDate'].", ".$statusFeb['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultMar) >0) {
$month++;
print "March";
print "
";
echo "- ";
while ($statusMar = mysqli_fetch_array($resultMar)) {
print "
- ".$statusMar['statusMonth']." ".$statusMar['statusDate'].", ".$statusMar['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultApr) >0) {
$month++;
print "April";
print "
";
echo "- ";
while ($statusApr = mysqli_fetch_array($resultApr)) {
print "
- ".$statusApr['statusMonth']." ".$statusApr['statusDate'].", ".$statusApr['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultMay) >0) {
$month++;
print "May";
print "
";
echo "- ";
while ($statusMay = mysqli_fetch_array($resultMay)) {
print "
- ".$statusMay['statusMonth']." ".$statusMay['statusDate'].", ".$statusMay['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultJun) >0) {
$month++;
print "June";
print "
";
echo "- ";
while ($statusJun = mysqli_fetch_array($resultJun)) {
print "
- ".$statusJun['statusMonth']." ".$statusJun['statusDate'].", ".$statusJun['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultJul) >0) {
$month++;
print "July";
print "
";
echo "- ";
while ($statusJul = mysqli_fetch_array($resultJul)) {
print "
- ".$statusJul['statusMonth']." ".$statusJul['statusDate'].", ".$statusJul['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultAug) >0) {
$month++;
print "August";
print "
";
echo "- ";
while ($statusAug = mysqli_fetch_array($resultAug)) {
print "
- ".$statusAug['statusMonth']." ".$statusAug['statusDate'].", ".$statusAug['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultSep) >0) {
$month++;
print "September";
print "
";
echo "- ";
while ($statusSep = mysqli_fetch_array($resultSep)) {
print "
- ".$statusSep['statusMonth']." ".$statusSep['statusDate'].", ".$statusSep['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultOct) >0) {
$month++;
print "October";
print "
";
echo "- ";
while ($statusOct = mysqli_fetch_array($resultOct)) {
print "
- ".$statusOct['statusMonth']." ".$statusOct['statusDate'].", ".$statusOct['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultNov) >0) {
$month++;
print "November";
print "
";
echo "- ";
while ($statusNov = mysqli_fetch_array($resultNov)) {
print "
- ".$statusNov['statusMonth']." ".$statusNov['statusDate'].", ".$statusNov['statusYear']." "; } print "
";
}
if (mysqli_num_rows($resultDec) >0) {
$month++;
print "December";
print "
";
?>
- ";
while ($statusDec = mysqli_fetch_array($resultDec)) {
print "
- ".$statusDec['statusMonth']." ".$statusDec['statusDate'].", ".$statusDec['statusYear']." "; } print "