The
<? (".$result.") ?>
is supposed to display the number of rows but it doesn't and if it has no rows than it should display it as (0)
<?
$pagetitle="Control Panel";
include("../include/head.php");
echo $harsss;
?>
<tr><td class=sys><small><a HREF=\"http://members.lycos.co.uk/philvia/admin/appeals.php";
<?
$sql="SELECT * FROM modded WHERE recont=4";
$result=mysql_query($sql);
$result=@mysql_num_rows($result);
$sql="SELECT * FROM modded WHERE recont=9";
$result2=mysql_query($sql);
$result2=@mysql_num_rows($result2);
?>
if ($board) { echo "?board=$board"; }
if ($topic) { echo "&topic=$topic"; }
echo "\">Contest Appeals Queue <? (".$result."-".$result2.") ?></a> |
<a HREF=\"http://members.lycos.co.uk/philvia/admin/modqueue.php";
<?
$sql="SELECT * FROM marked";
$result=mysql_query($sql);
$result=@mysql_num_rows($result);
?>
if ($board) { echo "?board=$board"; }
if ($topic) { echo "&topic=$topic"; }
echo "\">Moderation Queue <? (".$result.") ?></a> |
<a HREF=\"http://members.lycos.co.uk/philvia/admin/sugqueue.php";
<?
$sql="SELECT * FROM suggested";
$result=mysql_query($sql);
$result=@mysql_num_rows($result);
?>
if ($board) { echo "?board=$board"; }
if ($topic) { echo "&topic=$topic"; }
echo "\">Suggestion Queue <? (".$result.") ?></a> |
<a HREF=\"http://members.lycos.co.uk/philvia/admin/contqueue.php";
<?
$sql="SELECT * FROM modded WHERE contest=1 AND modby=$useridy AND recont=0";
$result=mysql_query($sql);
$result=@mysql_num_rows($result);
$acceptmods=0;
$result2=mysql_query("SELECT * FROM modded WHERE modby=$useridy AND contest=0 AND recont=0 ORDER BY contsec ASC");
while ($myrow=@mysql_fetch_array($result2)) {
$contbo=$myrow["contbody"];
$recontbo=$myrow["recontbody"];
if (($contbo) && (!$recontbo)) { $acceptmods=$acceptmods+1; }
}
?>
if ($board) { echo "?board=$board"; }
if ($topic) { echo "&topic=$topic"; }
echo "\">Contestion Queue <? (".$result."-".$acceptmods.") ?></a> |
<a HREF=\"http://members.lycos.co.uk/philvia/admin/reviewuser.php";
<?
$sql="SELECT * FROM users WHERE level = 4";
$result=mysql_query($sql);
$result=@mysql_num_rows($result);
?>
if ($board) { echo "?board=$board"; }
if ($topic) { echo "&topic=$topic"; }
echo "\">Review Users <? (".$result.") ?></a>
</td></small>
