43 lines
1.0 KiB
PHP
43 lines
1.0 KiB
PHP
<?php
|
|
include "db.php";
|
|
include "include/table.php";
|
|
|
|
db_query("USE hotlunch_previous");
|
|
|
|
$orderHeaders = array();
|
|
$orderItems = array();
|
|
|
|
$headers = db_query("SELECT * FROM hotlunch_order_header WHERE schedule_num = 2554 AND ordered_by_type != 'Concession'");
|
|
while ($row = db_fetch_assoc($headers)) {
|
|
$orderHeaders[] = $row;
|
|
}
|
|
|
|
$items = db_query("SELECT * FROM hotlunch_order_items WHERE schedule_num = 2554 AND ordered_by_type != 'Concession'");
|
|
while ($row = db_fetch_assoc($items)) {
|
|
$orderItems[] = $row;
|
|
}
|
|
|
|
echo(count($orderHeaders) . "\n");
|
|
echo(count($orderItems) . "\n");
|
|
|
|
db_query("USE hotlunch");
|
|
|
|
$header = new Table("hotlunch_order_header");
|
|
$items = new Table("hotlunch_order_items");
|
|
|
|
for ($i = 0; $i < count($orderHeaders); $i++) {
|
|
$row = $orderHeaders[$i];
|
|
extract($row);
|
|
$query = $header->BuildInsert('Yes');
|
|
db_query($query);
|
|
}
|
|
|
|
for ($i = 0; $i < count($orderItems); $i++) {
|
|
$row = $orderItems[$i];
|
|
extract($row);
|
|
$query = $items->BuildInsert('Yes');
|
|
db_query($query);
|
|
}
|
|
|
|
?>
|