\n Continue Shopping\n"; exit(); } $n=1; while($row = mysqli_fetch_assoc($result)) { foreach($row as $field => $value) { if($field != "order_id") { $items[$n][$field]=$value; if($field == "Part_ID") { $sql_prt = "SELECT Item_Desc,Item_PartNo FROM Items WHERE Item_ID = '$row[Part_ID]'"; $result_prt = mysqli_query($cxn,$sql_prt) or die("sql_prt: ".mysqli_error($cxn)); $row_prt = mysqli_fetch_array($result_prt); $items[$n]["Item_Desc"]=$row_prt['Item_Desc']; $items[$n]["Item_PartNo"]=$row_prt['Item_PartNo']; } } } $n++; } ?> IMS "; echo "

Order Number: $table_name\n"; echo ""; echo "

"; echo "\n"; echo ""; echo ""; foreach($table_headers as $header) { echo "\n"; } echo ""; echo ""; for($i=1;$i<=sizeof($items);$i++) { echo ""; echo ""; } echo ""; ?>
$header

{$items[$i]['Order_Item_No']}\n"; echo "{$items[$i]['Item_ID']}\n"; echo "{$items[$i]['Item_Desc']}\n"; echo "