Online Players

[corkg]

Hi

 

I have some code and it is for a online players page so it shows who is online i am trying to get it so that if there are no MODS online then it says no MODS.

 

I have the code for selecting the online mods below i tryed an else command but it returned nothing.

 

				$timenow=time();

$select = mysql_query("SELECT * FROM users WHERE online > '$timenow' ORDER by `rank` desc limit 99999999");
while ($ad = mysql_fetch_object($select)){

if($ad->userlevel=="1"){
echo"<font color=red><a href='viewprofile.php?viewuser=$ad->username'>$ad->username</a></font>";
}

}

[gerkintrigg]

try :

$q="SELECT * FROM users WHERE online > '$timenow' ORDER by `rank` desc limit 99999999"";
$select=mysql_query($q);
while($ad=mysql_fetch_array($select)){
   if($ad['userlevel']=="1"){
      echo"<font color=red><a href='viewprofile.php?viewuser=$ad->username'>$ad->username</a></font>";
   }
}

[corkg]

I need the else bit so if there is no Mods online

 

Thanks