18 lines
757 B
PHP
18 lines
757 B
PHP
<?php
|
|
|
|
$query = "SELECT hloi.order_num, hloi.school_num, hloi.ordered_by_num, hloi.ordered_by_type, hloi.schedule_num, hloi.menu_num, hloi.menu_item_num, hloi.menu_item_price, hloi.qty, hloi.extended_price,hloh.status,p.status,p.first_name,p.last_name " .
|
|
"FROM hotlunch_order_items AS hloi, hotlunch_order_header AS hloh, people AS p " .
|
|
"WHERE hloi.school_num = 271 " .
|
|
"AND hloh.school_num = 271 " .
|
|
"AND p.school_num = 271 " .
|
|
"AND hloi.order_num = hloh.record_num " .
|
|
"AND hloi.ordered_by_num = p.record_num " .
|
|
"AND hloi.schedule_num = 27881 " .
|
|
"AND hloi.menu_num = 351027 " .
|
|
"AND hloi.menu_item_num = 11537380";
|
|
|
|
// $results = db_query($query);
|
|
echo("$query\n");
|
|
|
|
?>
|