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." . " 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()) { ?>
(Rated )

fetch_assoc()) { echo "
" . "" . $currentrow['title'] . "". "". " (Rated " . $currentrow['rating'] . ")
" . "" . "
"; } */ ?>