0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Product_idProduct_NameUnit_priceNo_In_StockTo_Order
" . $row['Product_id'] . "" . $row['Product_Name'] . "" . $row['Unit_price'] . "" . $row['No_In_Stock'] . "" . $row['To_Order'] . "
"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>