01 |
if ($orderby== 'homecount' ) |
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 "; |
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 "; |
|