$sql = "SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid $wheresql order by mb.{$orderby} DESC LIMIT 0,$row "; |
if($orderby=='homecount') { $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join `dede_member_tj` ht ON ht.mid = mb.mid $wheresql order by ht.homecount DESC LIMIT 0,$row "; } else { $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join `dede_member_tj` ht ON ht.mid = mb.mid $wheresql order by mb.{$orderby} DESC LIMIT 0,$row "; } |
while($row = $dsql->GetArray('mb')) |
$GLOBALS['autoindex']='1'; |
$revalue .= $ctp->GetResult(); |
$GLOBALS['autoindex']++; |
{dede:memberlist row='15' orderby='homecount'} <li> <a href="../user/index.php?uid=[field:userid/]"> <span class="member_name">[field:global.autoindex/]、[field:uname/]</span> </a> </li> {/dede:memberlist} |