connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } ?> Drill down: Movie results

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 "
" . "" . $currentrow['title'] . "". " (Rated " . $currentrow['rating'] . ")
" . "" . "
"; } ?>