\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_name = "SELECT name,type FROM furniture WHERE catalog_number = '$row[catalog_number]'"; $result2 = mysqli_query($cxn,$sql_name) or die("sql_name: ".mysqli_error($cxn)); $row = mysqli_fetch_row($result2); $items[$n]["name"]=$row[0]." ".$row[1]; } } } $n++; } #44 echo " Order Summary\n \n"; echo "

Order Summary

\n"; echo "

Ship to:

"; echo "

$ship_name
"; echo "$ship_street
$ship_city, $ship_state $ship_zip
$phone
$email
"; #56 echo "

"; #57 echo "

Order Number: $table_name"; echo "\n"; echo ""; echo ""; foreach($table_headers as $header) #62 { echo "\n"; } echo ""; for($i=1;$i <=sizeof($items);$i++) #67 { echo ""; echo ""; echo ""; echo ""; echo ""; $f_price = number_format($items[$i]['price'],2); echo "\n"; $total = $items[$i]['quantity'] * $items[$i]['price']; $f_total = number_format($total,2); echo "\n"; echo ""; @$order_subtotal = $order_subtotal + $total; } $f_order_subtotal = number_format($order_subtotal,2); #85 if(substr($ship_zip,0,5) > 75000 #86 && substr($ship_zip,0,5) < 80000) #87 { $taxrate = .0700; } else { $taxrate = 0.0; } #94 $sales_tax = $order_subtotal * $taxrate; #95 $f_sales_tax = number_format($sales_tax,2); $shipping = $shipping_rate * sizeof($items); #97 $f_shipping = number_format($shipping,2); $order_total = $order_subtotal + $sales_tax + $shipping; #99 $f_order_total = number_format($order_total,2); #100 echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "
$header
$i {$items[$i]['catalog_number']}{$items[$i]['name']} {$items[$i]['quantity']}$$f_price$$f_total
Subtotal $$f_order_subtotal
Sales Tax $$f_sales_tax
Shipping $$f_shipping
Total $$f_order_total
\n"; ?>