[williamh26]

I am ttrying to count how many entries have the row but for some reason i have error this the code

PHP Code:

<?php

         login();

         $quest_sub_id = $_GET['cat'];

         $query="SELECT quest_sub_id, topic from topicquestion where quest_sub_id = $quest_sub_id ORDER BY topic ASC";

         $result=mysql_query($query);

         while($row=mysql_fetch_array($result,MYSQL_ASSOC))

         {

             $quest_sub_id = $row['quest_sub_id'];

             $topic = $row['topic'];

             $query2="SELECT count(quest_sub_id) FROM topicproblems WHERE quest_sub_id = $quest_sub_id ";

             $result2 = mysql_query($query2);

             $row=mysql_fetch_array($result2);

             $total = $row[0];



             echo "<h3><a href=\"index.php?content=problems&cat=$quest_sub_id\">$topic</a>($total)</h3><br>\n";

         }

       ?>

I have this error
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\chemath.com\topics.inc.php on line 13

thank your for your help

[phplabs]

it seems that lines 12-13 have this code (i'm referring to those lines because the warning says the problem is in line 13).

$result=mysql_query($query);
while($row=mysql_fetch_array($result,MYSQL_ASSOC))

the warning also says that parameter 1 ($result) is boolean, which probably means that $result is false here. you can check this using var_dump($result). if that is so, it means that you have an error in your query execution.

in general, it's a good idea to check if $result has a value before fetching the data:

$result=mysql_query($query);
if($result) {
// result is ok, fetching the data
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
...
}
else {
// some error occurred
}