<?php

include "db.php";
include "table.php";

$hotlunch_menu_dates = new Table("hotlunch_menu_dates");
$hotlunch_menu_items = new Table("hotlunch_menu_items");
$hotlunch_menu_products = new Table("hotlunch_menu_products");

$school_num = 365;
$menu_num = 64462;

db_query("use hotlunch_backup");
$query = "SELECT * FROM hotlunch_menu_dates WHERE record_num = $menu_num";

$results = db_query($query);
$row = db_fetch_assoc($results);
extract($row);
echo("$menu_title\n");
$hlmd_query = $hotlunch_menu_dates->BuildInsert('Yes');


$query = "SELECT * FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num";
$menu_items = db_query($query);
$hlmi = array();
$hlmp = array();
while ($row = db_fetch_assoc($menu_items)) {
   extract($row);
   $hlmi_query = $hotlunch_menu_items->BuildInsert('Yes');
   $hlmi[] = $hlmi_query;

   $query = "SELECT * FROM hotlunch_menu_products WHERE school_num = $school_num AND menu_item_num = $record_num";
   $menu_products = db_query($query);
   while ($row = db_fetch_assoc($menu_products)) {
      extract($row);
      $hlmp_query = $hotlunch_menu_products->BuildInsert('Yes');
      $hlmp[] = $hlmp_query;
   }
}


db_query("use hotlunch");
echo("$hlmd_query\n\n");
db_query($hlmd_query);

for ($i = 0; $i < count($hlmi); $i++) {
   $query = $hlmi[$i];
   db_query($query);
}

for ($i = 0; $i < count($hlmp); $i++) {
   $query = $hlmp[$i];
   db_query($query);
}


?>