= '" . date("Y-m-d") . "' AND start_date < '2999-00-00' AND (class_type = 'aq' OR class_type = 'rm' OR class_type = 'lft' OR class_type = 'ls') ORDER BY start_date LIMIT 6"); ////WHERE start_date BETWEEN NOW() AND '2998-00-00' this doesn't pull classes on today's date! while($row = mysql_fetch_array($result1)) { if ($row['full'] == 'N') { echo "document.write(\"

" . $row['class_name'] . "

" . $row['class_date_label'] . " (" . $row['comments'] . ")

\");\n"; } else { echo "document.write(\"

" . $row['class_name'] . "(Standby Only)
" . $row['class_date_label'] . " " . $row['comments'] . ")

\");\n"; } } mysql_close($con); ?>