query("select distinct team from {$dbtbpre}enewslinkclass order by team"); while($arlc=$empire->fetch($rslc)){ $rs=$empire->query("select a.*,b.CSS from {$dbtbpre}enewslink a left join {$dbtbpre}enewslinkclass b on a.classid=b.classid where a.classid in ( select classid from {$dbtbpre}enewslink where team='$arlc[team]') and a.checked=1 order by b.team,a.classid,a.myorder,a.lid"); if($empire->num1($rs)>0){ echo "

"; while($ar=$empire->fetch($rs)){ echo "
• $ar[lname]
"; } echo "

"; } } ?>