= '$today' " . "and status = 'Active' " . "order by $scheduleSortOrder " . "limit 0,1"; $schedules = db_query($query); unset($schedule_num); if (db_num_rows($schedules) > 0) { $row = db_fetch_array($schedules); $schedule_num = $row['record_num']; $schedule_name = $row['schedule_name']; } $mcommand = ""; if ($_SESSION['mode'] == 'parent') $mcommand = "&mode=parent"; $numClasses = db_getVal("SELECT count(*) FROM classes WHERE school_num = $base_school_num"); // Get the delete confirmation message $delete_msg = getLanguageText('TEXT-CONFIRM-DELETE'); ?>