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." .
" matching the genre " . $_REQUEST['genre'];
echo "
";
$name = "patrick" . " " . "dnet";
/*
below is the results loop that drops OUT of php
and outputs html tags in 'html' mode
and jumps back into php just to output
*/
while($currentrow = $results->fetch_assoc()) {
?>
fetch_assoc()) {
echo "
" .
"
" . " " . "
" .
"
";
}
*/
?>