25 lines
654 B
PHP
25 lines
654 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 418;
|
|
$schedule_num = 5677;
|
|
|
|
$query = "SELECT hlmi.*,hlmd.menu_date FROM hotlunch_menu_items AS hlmi, hotlunch_menu_dates AS hlmd " .
|
|
"WHERE hlmi.school_num = $school_num " .
|
|
"AND hlmd.school_num = $school_num " .
|
|
"AND hlmd.schedule_num = $schedule_num " .
|
|
"AND hlmd.record_num = hlmi.menu_num " .
|
|
"ORDER BY hlmd.sequence,hlmi.sequence";
|
|
$results = db_query($query);
|
|
|
|
$pmenu = 0;
|
|
while ($row = db_fetch_array($results)) {
|
|
extract($row);
|
|
|
|
if ($pmenu != $menu_num) echo("\n-- $menu_date --\n");
|
|
$pmenu = $menu_num;
|
|
|
|
echo("$item_title $active_until_date\n");
|
|
}
|
|
|