error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

Question

I received this message when my database table has no record so how to solve it.

$sql2 = mysql_query("SELECT ID,NAME from login where TYPE='AdPublish' ORDER BY ID ASC $limit") or mysql_error();

if(!$sql2)
{
    die("invalid query".mysql_error());
}
else
{
    while($data=mysql_fetch_array($sql2))
    {   
        $rv1=mysql_query("select LINK from url where ID='".$data['ID']."' AND STATUS='Pending'") or mysql_error();
        $count1=mysql_num_rows($rv1);
        echo '<a href="cidmatter.php?cid='.$data['ID'].'" target="_blank">';
        echo "<table>";
        echo '<tr><td><h4><b>ID: ' .$data['ID'].'</b></H4></td></tr><br>';
        echo '<br><tr><td><b>Name: ' .$data['NAME'].'</b>('.$count1.')</td></tr></table></a>';
        echo '<hr>';
    }
}

Delete ``` or mysql_error();``` at the end of the first line. — MrTux, Sep 06 '14 at 12:17
I don't think, your code have any error. share your remaining code. — Ram Sharma, Sep 06 '14 at 12:18

score 0 · Answer 1 · answered Sep 06 '14 at 12:20

0

use something like this

   $sql2 = mysql_query("SELECT ID,NAME from login where TYPE='AdPublish' ORDER BY ID ASC $limit") or die("Error in query");

    while($data=mysql_fetch_array($sql2)){   
        $rv1=mysql_query("select LINK from url where ID='".$data['ID']."' AND STATUS='Pending'") or die("Error in query");
        $count1=mysql_num_rows($rv1);
        echo '<a href="cidmatter.php?cid='.$data['ID'].'" target="_blank">';
        echo "<table>";
        echo '<tr><td><h4><b>ID: ' .$data['ID'].'</b></H4></td></tr><br>';
        echo '<br><tr><td><b>Name: ' .$data['NAME'].'</b>('.$count1.')</td></tr></table></a>';
        echo '<hr>';

}

answered Sep 06 '14 at 12:20

RN Kushwaha

1,985
3
27
38

Better you make a function and pass your query in this function and implement error handling. – RN Kushwaha Sep 06 '14 at 12:21
no change of this code also – purvi Sep 06 '14 at 12:25
ya your right but i put pagination in this page also but when one record in the page then error shown but when table is empty then this error is shown so what to do? – purvi Sep 06 '14 at 12:26

error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

1 Answers1