0) AS u INNER JOIN prices AS x WHERE i.id = u.productid AND i.id = x.productid;"; $result = mysqli_query($mysqli,$query); if ($result) { echo ""; for ($i = 0; $i < mysqli_num_fields($result); $i++) echo ""; // Action headers echo ""; echo ""; while ($row = $result->fetch_array(MYSQLI_NUM)) { echo ""; for ($i = 1; $i < 3; $i++) { if (file_exists(__DIR__.'/../productimgs/product'.$row[0].'.jpg')) echo ""; else echo ""; } for ($i = 3; $i < mysqli_num_fields($result); $i++) echo ""; // Action items echo ""; } echo "

" . mysqli_fetch_field_direct($result,$i)->name . "	Order
" . $row[0] . "	" . nullChecker($row[$i]) . "	" . nullChecker($row[$i]) . "	" . nullChecker($row[$i]) . "

"; } else { echo "Query failed: " . $mysqli->error; } ?> close(); ?>