hi
i`m working on chapter 4 and all worked fine untill i made the reviews section. actually it works to exept the number of reviews per movie: it shows only 1 review.

so if i understand the problem is with the sql query, this is what i have and its the same in the book:

$review_query = "SELECT * FROM reviews " .
                "WHERE review_movie_id ='" . $_GET['movie_id'] . "' " .
                "ORDER BY review_date DESC";

now, the movie_id does pass through the get method, so i think that maybe the problem is with the reviews table. when we build it there is no "movie_id" as a forighn key, so there is no connection between the tables.
am i right? and if not can someone please help? cause i`m trying to figure it for some hours now.

best regards

hi
i managed to fix the problem.