" . substr($days[$x],0,3) . ""; } ?>  \n"; } // counter to track the current date $dayCount=1; while ($dayCount <= $totalDays[$currMonth]) { // use this to find out when the 7-day block is complete and display a new row if ($rowCount % 7 == 0) { echo "\n\n"; } // if today, display in different colour // print date if ($dayCount == date("j") && $currYear == date("Y") && $currMonth == date("n")) { echo "\n"; // increment counters $dayCount++; $rowCount++; } ?>

                                                         Room Reservations
 
" . $dayCount. "  Today"; } else { echo "" . $dayCount . " "; } for ($y=0; $y"; $t=0; $query_t="SELECT * from room_reserve where approved='yes' and date = '" . $currYear . "-" . sprintf("%02d", $currMonth) . "-".$dateList[$y]."' order by location,time"; $result_t=MYSQL_QUERY($query_t); $number_t=MYSQL_NUMROWS($result_t); while($t<$number_t): $location=mysql_result($result_t,$t,"location"); $time=substr(mysql_result($result_t,$t,"time"),-8,5); $time2=substr(mysql_result($result_t,$t,"time2"),-8,5); echo "$time-$time2
$location


"; $t++; endwhile; //echo "$query_t + $result_t + $number_t"; //--------------- } } echo "
For more information on a reservation, click on the appropriate day number

     

 :: Return to Mathematics and Statistics Home Page