Jump to content

[SOLVED] mysql_num_rows


plutomed

Recommended Posts

while($blist = mysql_fetch_array($banlist))
{	

if(mysql_num_rows($banlist)==0){
	echo "<td colspan=\"2\">No IPs in the database</td>"; //<-----------this bit here
} else {
	echo "<td>" . $blist['ips'] . "</td>";
	echo "<td><a href=\"admincp.php?do=removeip&ip=" . $blist['ips'] . "\">Remove</a></td>";
}
}

 

this bit of code doesnt seem to work any ideas ??? the second bit after the else works but the if bit dont ???

Link to comment
https://forums.phpfreaks.com/topic/38928-solved-mysql_num_rows/
Share on other sites

try this:

 

while($blist = mysql_fetch_array($banlist))

{

        $banlist2 = mysql_num_rows($banlist);

if($banlist2==0){

echo "<td colspan=\"2\">No IPs in the database</td>"; //<-----------this bit here

} else {

echo "<td>" . $blist['ips'] . "</td>";

echo "<td><a href=\"admincp.php?do=removeip&ip=" . $blist['ips'] . "\">Remove</a></td>";

}

}

Link to comment
https://forums.phpfreaks.com/topic/38928-solved-mysql_num_rows/#findComment-187211
Share on other sites

You should check the returned rows before going into the while loop. So you should do this:

if(mysql_num_rows($banlist) < 1)
{
    echo '<td colspan="2">No IPs in the database</td>';
}
else
{
    while($blist = mysql_fetch_array($banlist))
    {
        echo '<td>' . $blist['ips'] . '</td>';
        echo '<td><a href="admincp.php?do=removeip&ip=' . $blist['ips'] . '">Remove</a></td>';
    }
}

Link to comment
https://forums.phpfreaks.com/topic/38928-solved-mysql_num_rows/#findComment-187212
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.