\n";
$qDays = mysql_query($sql) or die(mysql_error());
while($rDays = mysql_fetch_array($qDays)) {
$timeslots = 0;
$all_loc = "";
$sql = "SELECT * FROM timeslots
WHERE event_id = '$event_id'
AND day_num = $rDays[day_num] ";
echo "\n";
$qTime = mysql_query($sql) or die(mysql_error());
while ($rTime = mysql_fetch_array($qTime)) {
$timeslots++;
$time_number[$timeslots] = $rTime['start_time'];
$time_label[$timeslots] = $rTime['english'];
$sql = "SELECT * FROM schedule
WHERE event_id = '$event_id'
AND day = $rDays[day_num]
AND start_time = $rTime[start_time]
AND location = '*' ";
$qAllLoc = mysql_query($sql) or die(mysql_error());
if ($rAllLoc = mysql_fetch_array($qAllLoc)) {
$all_loc[$timeslots] = $rAllLoc['class_short_name'];
} else {
$all_loc[$timeslots] = "";
}
} // wend $rTime
?>
|
| |
|
|
";
} else {
?>
|
\n";
$qSched = mysql_query($sql) or die(mysql_error());
if ($rSched = mysql_fetch_array($qSched)) {
$len = $rSched['class_length'];
if ($len <= 0) { echo "\n"; $len = 1; }
?>
|
1) { echo "\n"; $j += $len - 1; }
} else {
echo " | \n";
} // endif $rSched
} // endif $all_loc
} // next $j
?>
|
