24 lines
756 B
PHP
24 lines
756 B
PHP
<pre>
|
|
<?php
|
|
|
|
include "db.php";
|
|
|
|
$today = date("Y-m-d",time());
|
|
|
|
$query = "SELECT school_name, schedule_name, s.record_num AS school_num, hls.record_num AS schedule_num FROM hotlunch_schedules AS hls, schools AS s " .
|
|
"WHERE hls.school_num = s.record_num " .
|
|
"AND schedule_end_date > '$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);
|
|
}
|
|
|
|
?>
|
|
</pre>
|