'$today' " .
         "AND schedule_start_date < '$today' " .
         "ORDER BY school_name, schedule_end_date, schedule_name";
$results = db_query($query);

while ($row = db_fetch_assoc($results)) {
   extract($row);
   $numMenus = db_getVal("SELECT count(*) FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num");
   if ($numMenus == 0) continue;
   printf("%-50s: %s\n", $school_name, $schedule_name);
}

?>