Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\classifieds\category.php on line 48

Question

i am getting this error as i was trying free classified script on http://www.tutorialized.com/tutorial/Create-Classifieds-Software-In-1-Hour/60523

this is the code and line 47

enter code here  
function list_count()
   {
       $q="SELECT COUNT(tA.id) as classifieds, tC.name as name, tC.id as id
       FROM categories as tC LEFT JOIN classifieds as tA ON tA.category_id=tC.id
       ORDER BY tC.name";
       $result=mysql_query($q);
       $cats=array();

   line 47->    while($cat=mysql_fetch_array($result)) $cats[]=$cat;
       return $cats;
   }

obviously your $result do not evaluate to MySQL resource. Maybe the query failts. Use mysql_error() to determine why it does fail — Royal Bg, Mar 13 '14 at 08:46
http://stackoverflow.com/questions/6575482/how-do-i-enable-error-reporting-in-php — Karoly Horvath, Mar 13 '14 at 08:50

score 0 · Answer 1 · answered Mar 13 '14 at 08:49

It means $result is getting a boolean value instead of resource type which it should have been if it was a succesful query.

So,there is some problem with the query.First check if the $result is not 'false' by a if statement and print the error using mysql_error() if its in fact false.

<?php
    if($result)
    {
        //Proceed with your previous code
    }else{
        echo "Query Failed, Reason :: ".mysql_error();
    }

Then you can proceed to mysql_fetch_array() as in your code.

score 0 · Answer 2 · answered Mar 13 '14 at 08:49

Your mysql_query return false. Refactor your code;

function list_count()
{
   $q="SELECT COUNT(tA.id) as classifieds, tC.name as name, tC.id as id
   FROM categories as tC LEFT JOIN classifieds as tA ON tA.category_id=tC.id
   ORDER BY tC.name";
   $result = mysql_query($q);
   if($result === FALSE) {
    die("Error occured: " . mysql_error());
   }

   $cats=array();   
   while($cat=mysql_fetch_array($result)) $cats[]=$cat;
   return $cats;
}

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\classifieds\category.php on line 48

2 Answers2