\n Continue Shopping\n"; exit(); } $n=1; #24 while($row = mysqli_fetch_assoc($result)) #25 { foreach($row as $field => $value) { if($field != "order_number") { $items[$n][$field]=$value; if($field == "catalog_number") { $sql_2 = "SELECT name,type FROM furniture WHERE catalog_number = '$row[catalog_number]'"; $result2 = mysqli_query($cxn,$sql_2) or die("sql_2: ".mysqli_error($cxn)); $row = mysqli_fetch_row($result2); $items[$n]["name"]=$row[0]." ".$row[1]; } } } $n++; } #44 echo " Furniture Shopping Cart\n \n"; echo "

The Furniture Shop

\n"; echo "

Shopping Cart

\n"; echo "

Order Number: $table_name


\n"; echo "\n"; echo ""; #54 echo ""; foreach($table_headers as $header) #56 { echo "\n"; } echo ""; echo "\n"; for($i=1;$i<=sizeof($items);$i++) #62 { echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $f_price = number_format($items[$i]['price'],2); echo "\n"; $total=$items[$i]['quantity'] * $items[$i]['price']; #77 $f_total = number_format($total,2); echo ""; @$order_total = $order_total + $total; } $f_order_total = number_format($order_total,2); #82 ?>
$header

{$items[$i]['item_number']} {$items[$i]['catalog_number']}{$items[$i]['name']} $$f_price$$f_total
Total $