connect_errno) {
echo "db connection error : " . $mysql->connect_error;
exit();
}
?>
Search results
query($sql);
if(!$results) {
echo "
Your SQL:
" . $sql . "
";
echo "SQL Error: " . $mysql->error . "
";
exit();
}
// echo "
You searched for Title: " . $_REQUEST['title'] . " and Rating: " . $_REQUEST['rating'] . " and Genre: " . $_REQUEST['genre'] . "";
// echo "
";
// echo "
(SQL: " . $sql . ")";
// echo "
";
echo "
Your results returned " .
$results->num_rows .
" results.";
echo "
";
while($currentrow = $results->fetch_assoc()) {
echo "
" .
"
" . " " . "
" .
"
";
}
?>