Make a Reservation | Add a New Instructor | Manage | Sign Out

END; $error = $_GET['error']; if ($error == "1") { echo "

You must enter a 5 digit CRN.

"; }elseif ($error == "2"){ echo "

Hey, Goofy, this is a duplicate ticket number. Please enter a new ticket number.

"; } print <<Add Classes for $FirstName $LastName

Semester:	END; $query = "SELECT Year, Semester from SR_semester WHERE EndDate >= CURDATE() and Status='1'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ( $semester == $row[1].' '.$row[0]) { print <<$row[1] $row[0] END; } else { print <<$row[1] $row[0] END; } } print <<
Department:	END; $query = "SELECT Department from SR_department"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ( $row[0]==$Department) { print <<$row[0] END; } else { print <<$row[0] END; } } print <<
Instructor:	END; $query = "SELECT InstructorID, FirstName, LastName from SR_instructor where Department='$Department' order by LastName"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ( $row[0]==$ID) { print <<$row[2], $row[1] END; } else { print <<$row[2], $row[1] END; } } print <<
Course ID:	Ex: SPAN 1
Course Title:
Ticket Number:	Ex: 059836
Days:	Ex: M_W____
Start Time:	Ex: 08:00A
End Time:	Ex: 10:00A

END; if ($ID != '') { print <<$semester class list for $FirstName $LastName: END; $query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime from SR_course WHERE InstructorID='$ID' and Year='$Syear' and Semester='$Semester'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { print << END; } print << END; } print << END; ?>

			Course ID	Title	Days	Begin Time	End Time
Delete	Edit	$row[2]	$row[0]	$row[1]	$row[3]	$row[4]	$row[5]	Transfer