connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit();
}
// now get the category data, there should be only 1 record
$sql = $dbconn->prepare("select productname, description, price, jewelleryid, designid, colourid, crystalid, charmid, productid
from product
where productid = ?");
$sql->bind_param('i', $productid);
// execute the query
$sql->execute();
// bind the fields
$sql->bind_result($productname, $description, $price, $jewelleryid, $designid, $colourid, $crystalid, $charmid, $productid);
$sql->store_result();
// check for 0 rows or > 1 rows, if so redirect to list
if ($sql->num_rows == 0 || $sql->num_rows > 1)
{
$redirect = "location: index.php";
header($redirect);
}
// get the row of data - you will need a loop if there is more than 1 row
$sql->fetch();
?>