/home/techb158/workloadmatch.com/Master
Edit: /home/techb158/workloadmatch.com/Master/preference_accounting.php (9416B)
prepare("SELECT Admin_ID FROM master_profile WHERE Master_ID = ?");
$q->bind_param("s", $Master_ID);
$q->execute();
$q->bind_result($Admin_ID);
$q->fetch();
$q->close();
?>
<?php echo $programName; ?> Teacher Preferences
Select a teacher, check courses and choose First or Second. Saved automatically.
| Select | Course Name | Priority |
|---|
| Select a teacher |
| Teacher | Course | Priority | Date |
|---|
query("
SELECT t.First_Name, t.Last_Name, c.Course_Name, tcp.Priority, tcp.Date_Time
FROM teacher_course_preferences tcp
JOIN teacher_profile t ON tcp.Teacher_ID = t.Teacher_ID
JOIN Courses c ON tcp.Course_ID = c.Course_ID
WHERE tcp.Program_ID = $programID
ORDER BY t.First_Name, c.Course_Name");
while ($rs = $qs->fetch_assoc()) {
$p = $rs['Priority'] == 1 ? 'First' : 'Second';
echo "| {$rs['First_Name']} {$rs['Last_Name']} | {$rs['Course_Name']} | $p | {$rs['Date_Time']} |
";
} ?>