Show a text when no entry...

[Mowgwai]

Hi!
I come from a game community and we just made a php-script to show what servers we have online. The information is taken from a stat database witch we already had before.

The problem we have is that we can't get a text to show up if there is no servers online. Would look alot better if there was a text like "No server online". Can anyone help us with this? Would be great!

The code is located on this page:
http://www.ozsquad.com/main.php

This is the code:

<?php


Echo("<table border='0 solid' cellspacing='0' cellpadding='0' width='220' bordercolor='6A482B' \n");
Echo("<tr>\n");
Echo("<td bgcolor='#845c39' height='0'>\n");
Echo("<p align='left'><font face='Verdana' size='2' color='#000000'><b>Name</b></font></p>\n");
Echo("</td>\n");
Echo("<td bgcolor='#845c39' height='0'>\n");
Echo("<p align='center'><font size='2' face='Verdana'><b>Type</b></font></p>\n");
Echo("</td>\n");
Echo("<td bgcolor='#845c39' height='0'>\n");
Echo("<p align='right'><font size='2' face='Verdana'><b>Players</b></font></p>\n");
Echo("</td>\n");

Echo("</tr>\n");

//#######The following connects to the MySQL server and sorts the members by the member id in ascending order
$pre_members = "_servers";
$phpbb_users = $mysql_Prefix."".$pre_members;
$connect=mysql_connect("$db_Hostname","$db_UserName","$db_Password");
mysql_select_db("$db_Database",$connect);
$phpbbshowmembers=mysql_query("SELECT * FROM $phpbb_users ORDER BY name ASC")or die (mysql_error());
while($s=mysql_fetch_array($phpbbshowmembers)){
$babserver=$s["servername"];
$babhost=$s["name"];
$gametype=$s["gametype"];
$numplayers=$s["numplayers"];
$maxplayers=$s["maxplayers"];
$dedicated=$s["dedicated"];
$row=$s["last_update"];
$ip=$s["ip"];
$id=$s["id"];

if($gametype == '0'){
$game = "COOP"; }
Elseif($gametype == '1'){
$game = "DM"; }
Elseif($gametype == '2'){
$game = "TDM"; }
Elseif($gametype == '3'){
$game = "KOTH"; }
Elseif($gametype == '4'){
$game = "TKOTH"; }
Elseif($gametype == '5'){
$game = "CTF"; }
Elseif($gametype == '6'){
$game = "S&D"; }
Elseif($gametype == '7'){
$game = "A&D"; }
Elseif($gametype == '8'){
$game = "FB"; }

$hhj = "2";
//#######The following repeats for every member:
//START


$thetime = time();
if($thetime > ($row + 120)) {


} else {

Echo("<tr>\n");
Echo("<td bgcolor='#90653F' height='0'>\n");
Echo("<p align='left'><font face='Verdana' size='1' color='#000000'>$babserver</font></p>\n");
Echo("</td>\n");
Echo("<td bgcolor='#90653F' height='0'>\n");
Echo("<p align='center'><font color='#000000' size='1' face='Verdana'>$game</font></p>\n");
Echo("</td>\n");
Echo("<td bgcolor='#90653F' height='0'>\n");
Echo("<p align='right'><font face='Verdana' size='1' color='#000000'>$numplayers / $maxplayers</font></p>\n");
Echo("</td>\n");
Echo("</tr>\n");
	}
//END

}



Echo("</table>\n");
?>

[TheDefender]

Not sure how you are determining if they are online or not, but...

It would go something like this:

$queryforonlinemembers=mysql_query("SELECT * FROM servers WHERE status = 'online'")or die (mysql_error()); 
IF(mysql_num_rows($queryforonlinemembers) > 0){

// Do this (echo out the list)

} else {

// Do this (echo your text message)

}

[Mowgwai]

Update
Well I found a way to get to this, the only problem now is that it will show "No servers online" 18 times. That because we have 18 servers listed. And even if 1 server is only it will show 17 offline and 1 online. Anyway, think I might find away around this if you could help me some...

	if($thetime > ($row + 120)) {

$noserver_membb='No Server Online';

} else {

$noserver_membb='Blank';

that is the code I'm working with right now. Is it possible to make this the way that it has to be 18 of the

	if($thetime > ($row + 120))

before anything happens?

a code like

	if(18*$thetime > ($row + 120))

Then I can get it solved... no iea if it is possible...