$sql = mysql_query("SELECT c.classid, c.title, sc.status FROM class AS c LEFT JOIN scheduleClasses AS sc ON (c.classid = sc.classid AND sc.scheduleId = $scheduleId ) WHERE c.qtr IN(1,2,3,4) ORDER BY c.ordinal");
while ($row = mysql_fetch_array($sql)) {
$classid = $row['classid'];
$status = $row['status'];
if ($status == 'NULL') $status = '';
echo "";
}
?>
$sql = mysql_query("SELECT c.classid, c.title, sc.status FROM class AS c LEFT JOIN scheduleClasses AS sc ON (c.classid = sc.classid AND sc.scheduleId = $scheduleId ) WHERE c.qtr IN(5,6,7,8) ORDER BY c.ordinal");
while ($row = mysql_fetch_array($sql)) {
$classid = $row['classid'];
$status = $row['status'];
if ($status == 'NULL') $status = '';
echo "";
}
?>
$sql = mysql_query("SELECT c.classid, c.title, sc.status FROM class AS c LEFT JOIN scheduleClasses AS sc ON (c.classid = sc.classid AND sc.scheduleId = $scheduleId ) WHERE c.qtr IN(9,10,11,12) ORDER BY c.ordinal");
while ($row = mysql_fetch_array($sql)) {
$classid = $row['classid'];
$status = $row['status'];
if ($status == 'NULL') $status = '';
echo "";
}
?>

