connect_error > 0) { die('Could not connect: ' . $dbconn->connect_error); exit(); } //Join the data to use user friendly names rather than IDs for data from foreign keys $query = " SELECT ProductID, ProductName, Description, Price, JewelleryID, DesignID, ColourID, CrystalID, CharmID FROM Product "; $result = mysqli_query($dbconn, $query); //Make the HTML Table for data output $datatable = ""; while($row = mysqli_fetch_array($result)) { //Change field names to lower case $row = array_change_key_case($row, CASE_LOWER); $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; } $datatable.= "

	Product Name	Description	Price £	Jewellery Type	Design	Colour	Crystal	Charm
Edit	" . htmlspecialchars($row['productname']). "	" . htmlspecialchars($row['description']). "	" . htmlspecialchars($row['price']). "	" . htmlspecialchars($row['jewelleryid']). "	" . htmlspecialchars($row['designid']). "	" . htmlspecialchars($row['colourid']). "	" . htmlspecialchars($row['crystalid']). "	" . htmlspecialchars($row['charmid']). "	Delete

"; //close connection mysqli_close($dbconn); ?>

Products