connect_error) die("Fatal Error");
$query = "SELECT * FROM customers";
$result = $conn->query($query);
if (!$result) die ("Database access failed");
$rows = $result->num_rows;
for ($j = 0 ; $j < $rows ; ++$j)
{
$row = $result->fetch_array(MYSQLI_NUM);
echo htmlspecialchars($row[0]) . " purchased ISBN " .
htmlspecialchars($row[1]) . ":
";
$subquery = "SELECT * FROM classics WHERE isbn='$row[1]'";
$subresult = $conn->query($subquery);
if (!$subresult) die ("Database access failed");
$subrow = $subresult->fetch_array(MYSQLI_NUM);
echo " " . htmlspecialchars("'$subrow[1]'") . " by " .
htmlspecialchars( $subrow[0]) . "
";
}
?>