<?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);
}

?>