$my_is_child" ; } else if ( $my_is_child != '' ){ $d_call = $my_is_child ; } else { $d_call = $my_call; } $d_times = $my_times ; $d_days = $my_days ; $d_room = $my_room ; if ( $my_url != "" && $my_teach != 'exam' && $my_teach != 'staff' ) { $d_teach = "" . $my_teach . "" ; } else { $d_teach = $my_teach ; } } else { // loop not 0 $d_times .= "
$my_times" ; $d_days .= "
$my_days" ; $d_room .= "
$my_room" ; if ( $my_call == $my_is_child ) { //echo "HEKO\n"; $d_call .= "
$my_is_child" ; } else if ( $my_lab && $my_enroll_lab ) { $d_call .= "
$my_is_child" ; } else { $d_call .= "
$my_is_child" ; } if ( $my_url != "" && $my_teach != 'exam' && $my_teach != 'staff' ) { $d_teach .= "
" . $my_teach . "" ; } else { $d_teach .= "
$my_teach" ; } } $loop++; } // end while through section if ( ($d_course == "MATS 4010") && ($d_call == $my_is_child) ) { // echo "HEKO $d_call\n
"; $d_call = " $my_call" ; } echo "$d_course $d_title $d_credit $d_call $d_times $d_days $d_room $d_teach \n" ; ; } // end if not zero } // end function $today= date("Y-m-d") ; $user="classes"; $password="take_me"; $database="class_sched"; $link = mysql_connect('localhost', $user, $password); $db_selected = mysql_select_db($database, $link) ; if ( !$db_selected ) { die( "Unable to select database"); } $query="SELECT * FROM semester WHERE enddate > '$today' AND id != '1' order by id ASC" ; $result=mysql_query($query) ; $result_sems=$result ; $num=mysql_numrows($result) ; $i=0; while ($i < $num) { $id=mysql_result($result,$i,"id") ; $name=mysql_result($result,$i,"name") ; $query2="SELECT DISTINCT sched.callnum from sched, course WHERE sched.coursenum = course.class AND sched.semester= '$id' ORDER by course.class ASC, sched.callnum ASC"; $result2=mysql_query($query2) ; $num2=mysql_num_rows($result2) ; if ( $num2 != 0 ) { echo "\n" ; echo "

$name The complete schedule of BGSU classes for $name is also available online.   \n"; $odd_or_even=0 ; echo " \n" ; } $x=0 ; while ($x < $num2) { $odd_or_even = 1-$odd_or_even ; $my_callnum=mysql_result($result2,$x,"callnum") ; // $query3="SELECT * from sched LEFT JOIN course ON sched.coursenum = course.class LEFT JOIN instructors ON sched.teacher = instructors.initials LEFT JOIN semester ON sched.semester = semester.id WHERE sched.callnum = '$my_callnum' AND sched.semester= '$id' ORDER BY sched.id" ; $query3="SELECT * from sched LEFT JOIN course ON sched.coursenum = course.class LEFT JOIN instructors ON sched.teacher = instructors.initials LEFT JOIN semester ON sched.semester = semester.id LEFT JOIN descriptions ON sched.coursenum = descriptions.class WHERE sched.callnum = '$my_callnum' AND sched.semester= '$id' ORDER BY sched.id"; $result3=mysql_query($query3) ; get_sem($name, $id, $result3, $odd_or_even) ; echo "\n\n"; $x++ ; } echo " Course Title Cr Call# Time Days Room Instructor   " ; echo "

" ; $i++; } echo "

---

Key to building names. (See the campus map or the link below to see where they are.)

" ; $start_sem = mysql_result($result_sems,0,'id'); $my_buildings = "SELECT DISTINCT SUBSTRING_INDEX(room, ' ', 1) AS room from sched WHERE room != '' AND semester >= '$start_sem' order by room ASC" ; $build_result=mysql_query($my_buildings) ; $build_num=mysql_numrows($build_result) ; $build=0 ; while ($build < $build_num ) { $one_building=mysql_result($build_result,$build,"room") ; $my_location = "SELECT * FROM buildings where short = '$one_building'"; $locate_result= mysql_query($my_location) ; $short=mysql_result($locate_result,0,"short"); $name=mysql_result($locate_result,0,"name"); $url=mysql_result($locate_result,0,"url"); echo ""; $build++ ; } // buildings echo "

	$short	"; echo $name ; echo "

"; mysql_close() ; ?>