时间:2021-07-21人气:-
1$sql = "SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb2LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid3$wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";01if($orderby=='homecount')02{03$sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb04LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid leftjoin`dede_member_tj` ht ON ht.mid = mb.mid05$wheresql order by ht.homecount DESC LIMIT 0,$row ";06}07else08{09$sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb10LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid leftjoin`dede_member_tj` ht ON ht.mid = mb.mid11$wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";12}