Warning: Undefined array key "min_rating" in /home/sfeil/public_html/infost440/week10/movie_logs/inclass_searchmovies/handle_ratingrange.php on line 23
Warning: Undefined array key "max_rating" in /home/sfeil/public_html/infost440/week10/movie_logs/inclass_searchmovies/handle_ratingrange.php on line 24
SELECT * FROM movies WHERE rating >= AND rating <= ORDER BY rating DESC
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND rating <= ORDER BY rating DESC' at line 1 in /home/sfeil/public_html/infost440/week10/movie_logs/inclass_searchmovies/handle_ratingrange.php:30
Stack trace:
#0 /home/sfeil/public_html/infost440/week10/movie_logs/inclass_searchmovies/handle_ratingrange.php(30): mysqli_query(Object(mysqli), 'SELECT * FROM m...')
#1 {main}
thrown in /home/sfeil/public_html/infost440/week10/movie_logs/inclass_searchmovies/handle_ratingrange.php on line 30