[SOLVED] mysql_num_rows

[plutomed]

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 ???

[JJohnsenDK]

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>";

}

}

[wildteen88]

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>';
    }
}

[plutomed]

yes thanks wildteen88 it works thanks to all you others aswell