Warning error, please help!

kscritch · May 2nd, 2005, 04:42 PM

I am completely new to programming and need to learn php and mysql. My problem is that in the book I am running into the following error while trying to do the lesson, which is keeping me from progressing further in the book can someone please help me out on this?

In chapter 3 in the select.php lesson, there is a part of the code that says: while ($row = mysql_fetch_array($results)) {
When I load this in the browser I get the following message:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\wamp\www\test\select.php on line 17

Can someone please tell me what this means and how to fix it?

statusquo · May 2nd, 2005, 08:57 PM

Instead of using while ($row = mysql_fetch_array($results)) {,

I used while ($row = mysql_fetch_assoc($results)) { and it worked fine.

codepoet · December 9th, 2005, 01:57 AM

Still does not work for me.

Quote:

quote:Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\sandbox\select.php on line 13

Using:

Code:

<?php
   include "mysql_connect.php";

   // make sure we're using the right database
   mysql_select_db( "wiley" );

   $query = "SELECT movie_name, movie_type
         FROM movie
         WHERE movie_year>1990
         ORDER BY movie_type";
   $results = mysql_query( $query ) || die( mysql_error() );

   while ($rows = mysql_fetch_assoc( $results )) {
         extract( $rows );
         echo $movie_name;
         echo " - ";
         echo $movie_type;
         echo "<br>";
   }
?>

dbdave · December 12th, 2005, 04:33 PM

Thios will happen if no results are returned. Are you sure that you've inserted the data into the table?