01   if($orderby=='homecount')  

02       {  

03       $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb  

04           LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid  

05           $wheresql order by ht.homecount DESC LIMIT 0,$row ";  

06       }  

07       else  

08       {  

09           $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb  

10           LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid  

11           $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";  

12       }