View Single Post
Old
  (#13 (permalink))
Mighty_Y
Moderator
 
Status: Offline
Posts: 957
Join Date: Nov 2002
Location: Belgium
08-09-2003, 01:43 PM

replace the code with this one
Code:
<TD WIDTH="55%"><FONT CLASS="newstitle"><?=_WCROOMDESC?></FONT></TD>
      <TD WIDTH="10%"><FONT CLASS="newstitle"><?=_WCROOMOCCUPANTS?></FONT></TD>
    </TR>
<?
  $sql = "select ".$prefix."_chatroom.*, count(".$prefix."_chatuser.rid) as users from ".$prefix."_chatroom left join ".$prefix."_chatuser on ".$prefix."_chatuser.rid = ".$prefix."_chatroom.rid group by ".$prefix."_chatroom.rid order by ".$prefix."_chatroom.typ, ".$prefix."_chatroom.name";
  $q=sql_query($sql);
  if(sql_numrows($q) == 0){
    echo "<TR BGCOLOR=$bgcolor2><TD COLSPAN=\"4\"><FONT CLASS=normal><CENTER>"._WCNOACTIVE."</CENTER></FONT></TD></TR>"; 
  } else { 
    while($row=sql_fetcharray($q)) {
      echo "<TR BGCOLOR=$bgcolor2><TD><FONT CLASS=normal><a href=\"modules.php?op=modload&name=".$ModName."&file=index&roomid=$row[rid]\">$row[name]</a></TD>";


Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!
   
Reply With Quote