Spring Sports

Announcements

Week of March 3 Athletics Schedule


"; for($i = 0; $i < 7; $i++) { if($i == $day_of_week) { echo ""; } else { echo ""; } } echo ""; $start_of_week = explode("/", JDToGregorian($start_of_week)); $end_of_week = explode("/", JDToGregorian($end_of_week)); $startMonth = $start_of_week[0]; $startDay = $start_of_week[1]; $startYear = $start_of_week[2]; $endMonth = $end_of_week[0]; $endDay = $end_of_week[1]; $endYear = $end_of_week[2]; $query = "SELECT * FROM calendar_events WHERE ". "(event_date_year=$startYear OR event_date_year_end=$endYear". " OR event_date_year_end=$startYear OR event_date_year=$endYear)". " AND (event_date_month=$startMonth OR event_date_month_end=$endMonth". " OR event_date_month_end=$startMonth OR event_date_month=$endMonth)"; $result = mysql_query($query, $server); for($i = 0; $i < 7; $i++) { $today = $current_day - $day_of_week + $i; if($i == $day_of_week) { echo ""; } echo "
"; echo ""; echo day_of_week($i); echo "
"; $date = JDToGregorian(($i - $day_of_week) + $current_day); echo $date; echo "
"; echo day_of_week($i); echo "
"; $date = JDToGregorian(($i - $day_of_week) + $current_day); echo $date; echo "
"; $date = ($i - $day_of_week) + $current_day; $dateGreg = explode("/", $date); } else { echo "
"; $date = ($i - $day_of_week) + $current_day; $dateGreg = explode("/", $date); } for($j = 0; $j < mysql_num_rows($result); $j++) { $event_date_day = mysql_result($result, $j, "event_date_day"); $event_date_month = mysql_result($result, $j, "event_date_month"); $event_date_year = mysql_result($result, $j, "event_date_year"); $event_date_day_end = mysql_result($result, $j, "event_date_day_end"); $event_date_month_end = mysql_result($result, $j, "event_date_month_end"); $event_date_year_end = mysql_result($result, $j, "event_date_year_end"); $event_start = GregorianToJD($event_date_month, $event_date_day, $event_date_year); $event_end = GregorianToJD($event_date_month_end, $event_date_day_end, $event_date_year_end); $event_id = mysql_result($result, $j, "event_id"); $event_cat = mysql_result($result, $j, "event_cat"); $event_cat = explode(":", $event_cat); $event_name = mysql_result($result, $j, "event_name"); if($cat_list != NULL) { $cat_temp = explode(":", $cat_list); if(count(array_intersect($cat_temp, $event_cat)) > 0) { if($event_end != 0) { if($event_end >= $today && $event_start <= $today) { echo "• $event_name
"; } } else { if($event_start == $today) { echo "• $event_name
"; } } } } else { if($event_end != 0) { if($event_end >= $today && $event_start <= $today) { echo "• $event_name
"; } } else { if($event_start == $today) { echo "• $event_name
"; } } } } echo "
"; function month($month) { switch($month) { case 0: return "January"; break; case 1: return "Febuary"; break; case 2: return "March"; break; case 3: return "April"; break; case 4: return "May"; break; case 5: return "June"; break; case 6: return "July"; break; case 7: return "August"; break; case 8: return "September"; break; case 9: return "October"; break; case 10: return "Novemeber"; break; case 11: return "December"; break; } } function day_of_week($day) { switch($day) { case 0: return "Sunday"; break; case 1: return "Monday"; break; case 2: return "Tuesday"; break; case 3: return "Wednesday"; break; case 4: return "Thursday"; break; case 5: return "Friday"; break; case 6: return "Saturday"; break; } } ?>