$ss = ""; //END $es = ""; echo "\n"; echo "\t\n\t\t\n"; $last_semester = ''; while($row = mssql_fetch_assoc($result)){ // Should the row be visible? if ($row['showOnCalendar']){ // Set the current semester $current_semester = $row['sectionOrder']; // Is this a new semester? if( $last_semester != $current_semester ) { echo "\t\n\t\n\t\t\n\t\n"; } // Is this a holiday? if ($row['isUniversityClosed']){ $ss = ""; $es = ""; } echo "\t\n\t\t\n\t\t\n\t\t\n\t\n"; $es = ""; $ss = ""; $last_semester = $current_semester; } } echo "\t\n

" . $row['section2'] . "

" . $ss . date("M j", strtotime($row['startDate'])); if ($row['startDate'] != $row['endDate']){ //Start date month $ms = (string)date("M", strtotime($row['startDate'])); //End date month $me = (string)date("M", strtotime($row['endDate'])); if ($ms == $me){ echo "-" . date("j", strtotime($row['endDate'])); } else { echo " - " . date("M j", strtotime($row['endDate'])); } } echo $es . "" . $ss . $row['name2'] . $es; if (strlen($row['notes2']) != 0){ echo "" . str_replace("\n", "
", $row['notes2']) . ""; } echo "		" . $ss . date("D", strtotime($row['startDate'])); if ($row['startDate'] != $row['endDate']){ echo " - " . date("D", strtotime($row['endDate'])); } echo $es."
"; mssql_close($dbhandle); ?>