39 lines
1.3 KiB
PHP
39 lines
1.3 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 365;
|
|
$schedule_num = 4754;
|
|
|
|
$menus = db_query("SELECT * FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num ORDER BY sequence");
|
|
|
|
while ($row = db_fetch_assoc($menus)) {
|
|
extract($row);
|
|
|
|
echo("$menu_title\n");
|
|
$menu_num = $record_num;
|
|
|
|
$items = db_query("SELECT hlmi.*,sp.sequence AS seq " .
|
|
"FROM hotlunch_menu_items AS hlmi, hotlunch_menu_products AS hlmp, supplier_products AS sp " .
|
|
"WHERE hlmi.school_num = $school_num " .
|
|
"AND hlmp.school_num = $school_num " .
|
|
"AND sp.school_num = $school_num " .
|
|
"AND hlmi.menu_num = $menu_num " .
|
|
"AND hlmi.record_num = hlmp.menu_item_num " .
|
|
"AND product_sequence = 1 " .
|
|
"AND sp.record_num = hlmp.supplier_product_num " .
|
|
"ORDER BY sp.sequence");
|
|
if (db_num_rows($items)) {
|
|
while ($row = db_fetch_assoc($items)) {
|
|
extract($row);
|
|
echo(" - $item_title\n");
|
|
db_query("UPDATE hotlunch_menu_items SET sequence = $seq " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND menu_num = $menu_num " .
|
|
"AND record_num = $record_num");
|
|
}
|
|
}
|
|
echo("\n");
|
|
}
|
|
|
|
?>
|