35 lines
837 B
PHP
35 lines
837 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$school_num = 20096;
|
|
|
|
$Tables = array(
|
|
'hotlunch_menu_dates_classes',
|
|
'hotlunch_menu_items',
|
|
'hotlunch_menu_items_classes',
|
|
'hotlunch_menu_transactions',
|
|
'hotlunch_order_items',
|
|
'hotlunch_order_items_save',
|
|
'hotlunch_volunteers'
|
|
);
|
|
|
|
$primary_menu_num = 765209;
|
|
$secondary_menus = array(765211,765212);
|
|
|
|
|
|
for ($i = 0; $i < count($secondary_menus); $i++) {
|
|
$menu_num = $secondary_menus[$i];
|
|
echo("Menu Num: $menu_num\n");
|
|
|
|
for ($j = 0; $j < count($Tables); $j++) {
|
|
$table_name = $Tables[$j];
|
|
$query = "UPDATE $table_name SET menu_num = $primary_menu_num WHERE school_num = $school_num AND menu_num = $menu_num";
|
|
echo("$query\n");
|
|
db_query($query);
|
|
}
|
|
}
|
|
|
|
|
|
?>
|