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=mysql_query($sql);
if(mysql_num_rows($q) == 0){
echo "<TR BGCOLOR=$bgcolor2><TD COLSPAN=\"4\"><FONT CLASS=normal><CENTER>"._WCNOACTIVE."</CENTER></FONT></TD></TR>";
} else {
while($row=mysql_fetch_array($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>";
P.S. The top is off of MrCulinary.com the one that has the error message. and the bottom one is from JSM-Inc.com
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=mysql_query($sql);
if(mysql_num_rows($q) == 0){
echo "<TR BGCOLOR=$bgcolor2><TD COLSPAN=\"4\"><FONT CLASS=normal><CENTER>"._WCNOACTIVE."</CENTER></FONT></TD></TR>";
} else {
while($row=mysql_fetch_array($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>";