\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 "
Order Number: $table_name