: ') ?> : : :   : 0) $snums .= ","; $snums .= $row['record_num']; } // Get set of schedules $squery = "SELECT DISTINCT hls.* FROM hotlunch_schedules AS hls, hotlunch_volunteers AS hlv " . "WHERE hls.school_num IN ($snums) " . "AND hls.status IN ('Active','Pending','Closed') " . "AND hls.school_num = hlv.school_num " . "AND hls.record_num = hlv.schedule_num " . "AND hlv.deleted != 'Y' " . "AND hls.end_order_datetime > '$cutoff' " . "ORDER BY $scheduleSortOrder"; $schedules = db_query($squery); if (db_num_rows($schedules) > 0) { ?> : '$today' " . "order by sequence,menu_date"; $menu_dates = db_query($query); if (db_num_rows($menu_dates)) { echo(" \n"); while ($row = db_fetch_assoc($menu_dates)) { $mtitle = $row['menu_title']; $mdate = date("D M j, Y",strtotime($row['menu_date']) + 60 * 60 * 10); $mnum = $row['record_num']; $numVolunteers = db_getVal("SELECT count(*) FROM hotlunch_volunteers WHERE school_num = $school_num AND schedule_num = $sched AND menu_num = $mnum AND deleted != 'Y'"); $selected = ""; if (isset($current_menu_num) && $current_menu_num == $mnum) $selected = " selected='selected'"; echo(" ($numVolunteers) $mtitle - $mdate\n"); } echo(" \n"); } } ?> : ($numVolunteers) $stitle\n"); } ?>   : : $user - $name\n"); } ?> : $name $class_info\n"); } ?> 0) $ext = $f; ?> : 0) { $size = $numCategories; if ($size > 10) $size = 10; ?> : " . $r['category'] . "\n"); } ?>   :
:
: '$cutoff' " . "ORDER BY link_sequence,$scheduleSortOrder"; $schedules = db_query($query); $pschool = 0; while ($row = db_fetch_assoc($schedules)) { $snum = $row['school_num']; $stitle = $row['schedule_name']; $sched = $row['record_num']; if ($snum != $pschool) { if ($pschool != 0) echo(" \n"); $sname = db_getVal("SELECT school_name FROM schools WHERE record_num = $snum"); echo(" \n"); $pschool = $snum; } echo(" $stitle\n"); } if ($pschool != 0) echo(" \n"); ?>
:   : '$cutoff' " . "ORDER BY link_sequence,$scheduleSortOrder"; $schedules = db_query($query); while ($row = db_fetch_assoc($schedules)) { $stitle = $row['schedule_name']; $sched = $row['record_num']; $numItems = db_getVal("SELECT count(*) FROM hotlunch_menu_dates AS hlmd, hotlunch_menu_items AS hlmi " . "WHERE hlmd.school_num IN ($snums) " . "AND hlmi.school_num IN ($snums) " . "AND hlmd.schedule_num = $sched " . "AND hlmi.menu_num = hlmd.record_num"); if ($numItems == 0) continue; echo(" \n"); $menu_dates = db_query("SELECT * FROM hotlunch_menu_dates WHERE school_num IN ($snums) AND schedule_num = $sched ORDER BY sequence,menu_date"); while ($row = db_fetch_assoc($menu_dates)) { $mtitle = $row['menu_title']; $mdate = date($school_record['date_format'],strtotime($row['menu_date']) + 60 * 60 * 10); $mnum = $row['record_num']; echo(" \n"); $menu_items = db_query("SELECT * FROM hotlunch_menu_items WHERE school_num IN ($snums) AND menu_num = $mnum ORDER BY menu_num,sequence"); while ($row = db_fetch_assoc($menu_items)) { if ($row['item_type'] != 'Item') continue; $mitem = $row['item_title']; $item_num = $row['record_num']; echo("      - $mitem\n"); } } } ?>
  0) { $title = $school_record['link_title']; if (strlen($title) == 0) $title = $school_record['school_name']; ?> : $title\n"); } ?>
:   Amount:
The Amount value is only used when "Greater Than Specifed Amount" is selected   : 0) { $size = db_num_rows($cresults); if ($size > 10) $size = 10; ?>   :

$class_info\n"); } ?>