Code: Select all
$option_block1 = "";
$username = $_SESSION['username'];
$counter = 0;
$datearr[0] = 2010-01-21;
$sqlarr[]='';
$resultarr[]='';
$sqleoc = "SELECT * FROM MidCourseSurveys ORDER BY date";
$resultseoc = mysql_query($sqleoc,$connection);
while ($row = mysql_fetch_array($resultseoc, MYSQL_ASSOC)) {
foreach($datearr[$counter] as $value) {
$sqlarr[$counter] = "SELECT DISTINCT course_title, course_dept_num FROM MidCourseSurveys WHERE date < '$value' ORDER BY course_dept_num";
$resultarr[$counter] = mysql_query($sqlarr[$counter],$connection);
while ($row = mysql_fetch_array($resultarr[$counter], MYSQL_ASSOC)) {
$course_title = $row['course_title'];
$course_dept_num = $row['course_dept_num'];
if (substr($value, 5, 2) == '01') {
$semester = "FALL" . (substr($value, 0, 3) - 1);
} elseif (substr($value, 5, 2) == '06') {
$semester = "SPRING" . (substr($value, 0, 3));
} else {
$semester = "SUMMER" . (substr($value, 0, 3));
}
$option_block1 .= "<option value=\"$course_dept_num\">$course_dept_num: $course_title - $semester</option>";
$counter++;
$datearr[1] = 2010-06-01;
}
}
}