35 lines
1.0 KiB
PHP
35 lines
1.0 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$school_num = 282;
|
|
$source_items = array(194704,194705,194706,194707);
|
|
|
|
for ($s = 0; $s < count($source_items); $s++) {
|
|
$source = $source_items[$s];
|
|
|
|
$results = db_query("SELECT record_num FROM hotlunch_menu_items WHERE source_item = $source");
|
|
if (db_num_rows($results)) {
|
|
|
|
$linked = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$linked[] = $row['record_num'];
|
|
}
|
|
|
|
$query = "SELECT * FROM hotlunch_order_items WHERE school_num = $school_num AND menu_item_num = $source";
|
|
$results = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$order_num = $row['order_num'];
|
|
$options_ordered = db_escape_string($row['options_ordered']);
|
|
|
|
for ($i = 0; $i < count($linked); $i++) {
|
|
$item = $linked[$i];
|
|
db_query("UPDATE hotlunch_order_items SET options_ordered = '$options_ordered' WHERE school_num = $school_num AND order_num = $order_num AND menu_item_num = $item");
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|