p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 (http://p2p.wrox.com/forumdisplay.php?f=160)
-   -   problems with the reviews table in chapter 4 (http://p2p.wrox.com/showthread.php?t=55142)

derrida March 9th, 2007 05:44 AM

problems with the reviews table in chapter 4
 
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



derrida March 15th, 2007 03:58 AM

hi
i managed to fix the problem.



All times are GMT -4. The time now is 09:19 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.