<?php

$school_num = 18797;
$schedule_num = 63533;


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


$query = "SELECT order_num,ordered_by_num,menu_num,menu_item_num,count(*) " .
         "FROM hotlunch_order_items " .
         "WHERE school_num = $school_num " .
         "GROUP BY 1,2,3,4 " .
         "HAVING count(*) > 1";
$results = db_query($query);
$Items = array();
while ($row = db_fetch_assoc($results)) {
   $Items[] = $row;
}


echo("Items: ".count($Items)."\n");

$x = readline("Continue ");


for ($i = 0; $i < count($Items); $i++) {
   $row = $Items[$i];
   extract($row);

   $query = "SELECT record_num FROM hotlunch_order_items " .
            "WHERE school_num = $school_num " .
            "AND order_num = $order_num " .
            "AND ordered_by_num = $ordered_by_num " .
            "AND menu_num = $menu_num " .
            "AND menu_item_num = $menu_item_num " .
            "ORDER BY record_num DESC " .
            "LIMIT 0,1";
   $results = db_query($query);
   $row = db_fetch_assoc($results);
   $rnum = $row['record_num'];

   $query = "DELETE FROM hotlunch_order_items " .
            "WHERE school_num = $school_num " .
            "AND record_num = $rnum";
   db_query($query);
}


?>