I apparently need another set of eyes here. I am in chpt 4 setting up the review. I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\test\movie_details.php on line 112

It has to do with this block of code but I can figure it out.

while($review_row = mysql_fetch_array($review_result))
{
     $review_flag =1;
     $review_title[] = $review_row['review_name'];
     $reviewer_name[] = ucwords($review_row['review_reviewer_name']);
     $review[] = $review_row['review_comment'];
     $review_date[] = $review_row['review_date'];
     $review_rating[] = generate_ratings($review_row['review_rating']);
}

-Chris

This usually indicates an error in the query itself.

Try including some error reporting at the query, one such method:

if (!$review_result = mysql_query("..blah blah blah.."))
{
   echo mysql_error();
}

If the query handle returns FALSE, it'll echo some error text and tell you what's wrong with the query. Since the result handle is FALSE, mysql_fetch_array cannot then fetch the array, that's why the error pops up there.

Regards,
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

Still can't figure this out.

To see the code go to
http://www.chris-kaiser.net/code/movie_details.txt


-Chris

I figured it out!

Had the following code:

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

$review_result = mysql_query($review_query,$link) or die(mysql_error());

after the while statement when it should have been before the while statement. DUH! Guess I just needed to step away for a while and come back to it.

-Chris