SetQuery("SELECT uid,username FROM #@__group_user WHERE gid='{$id}' ORDER BY jointime DESC LIMIT 0,8");
$db->Execute();
while($rs = $db->GetArray()){
$newmenber .= "
".$rs['username']."\n";
}
//最多回贴
$db->SetQuery("SELECT uid,username,replies FROM #@__group_user WHERE gid='{$id}' ORDER BY replies DESC LIMIT 0,5");
$db->Execute();
while($rs = $db->GetArray()){
$replies .= "".$rs['username']." (".$rs['replies'].")\n";
}
//最多发贴
$db->SetQuery("SELECT uid,username,posts FROM #@__group_user WHERE gid='{$id}' ORDER BY posts DESC LIMIT 0,5");
$db->Execute();
while($rs = $db->GetArray()){
$posts .= "".$rs['username']." (".$rs['posts'].")\n";
}
//小分类
if($smalltype!='0'){
$smalltype = @explode(",",$smalltype);
foreach($smalltype as $rs){
$rs = @explode("|",$rs);
$selected = "";
if($typeid==$rs[1]) $selected = "style='color:red;'";
$smalltypes .= "".$rs[0]."\n";
}
}
?>