// $query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime from SR_course WHERE InstructorID='$ID' and Year='$Syear' and Semester='$Semester'";
$query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime, SR_course.Year, SR_course.Semester, FirstName, LastName, SR_course.InstructorID from SR_course, SR_semester, SR_instructor WHERE SR_course.InstructorID=SR_instructor.InstructorID and SR_semester.Year=SR_course.Year and SR_semester.Semester=SR_course.Semester and SR_semester.Status='1'";
if ($dpt != '')
{
$query .= " and SR_instructor.Department='$dpt'";
}
$query .= " order by ClassID";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$num_rows = mysql_num_rows($result);
if ($dpt == '')
{
print <<
Class List of All Departments: $num_rows
END;
}
else
{
print <<Class List of $dpt Department: $num_rows
END;
}
print <<
Add |
Semester |
Ticket # |
Course ID |
Title |
Days |
Begin Time |
End Time |
Instructor |
|
END;
while ($row = mysql_fetch_row($result))
{
print <<
Delete |
$row[7] $row[6] |
$row[2] |
$row[0] |
$row[1] |
$row[3] |
$row[4] |
$row[5] |
$row[8] $row[9] |
Transfer |
END;
}
print <<
END;
?>