16 lines
478 B
PHP
16 lines
478 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$school_num = readline("School Number: ");
|
|
$schedule_num = readline("Schedule Number: ");
|
|
$menu_num = readline("Menu Number: ");
|
|
$menu_item_num = readline("Menu Item Number: ");
|
|
|
|
$query = "SELECT sum(qty) FROM hotlunch_order_items WHERE school_num = $school_num AND schedule_num = $schedule_num AND menu_num = $menu_num AND menu_item_num = $menu_item_num";
|
|
$qty_ordered = db_getVal($query);
|
|
|
|
echo("Qty Ordered: $qty_ordered\n");
|
|
|
|
?>
|