wmd:memberlist按照空间点击数homecount排序并加上序号的办法

$sql = "SELECT mb.*,ms.spacename,ms.sign FROM `wmd_member` mb
        LEFT JOIN `wmd_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 `wmd_member` mb
        LEFT JOIN `wmd_member_space` ms ON ms.mid = mb.mid left join  `wmd_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 `wmd_member` mb
        LEFT JOIN `wmd_member_space` ms ON ms.mid = mb.mid left join  `wmd_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']++; 

 {wmd: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>
  	  {/wmd:memberlist}