Copyright @ 2015-2024 织梦园 版权所有 Power by DedeCms
鲁ICP备15039853号-2

模板标签 TAG标签 网站地图 XML地图 今日更新 返回顶部
$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}
|