= '" . date("Y-m-d") . "' AND start_date < '2999-00-00' AND (class_type = 'lft' OR class_type = 'aq' OR class_type = 'rm' OR class_type = 'ital_index' OR class_type = 'ls') ORDER BY start_date"); echo "document.write(\"--Select Alternate Class (Optional)--\");\n"; while($row = mysql_fetch_array($result1)) { $row['start_date'] = date("M j", strtotime($row['start_date'])) . ", " . date("Y", strtotime($row['start_date'])); if ($row['full'] == 'N') { echo "document.write(\"" . $row['class_date'] . "\");\n"; } else { echo "document.write(\"" . $row['class_date'] . " (Full--Standby Only)\");\n"; } } echo "document.write(\"\");\n"; mysql_close($con); ?>