如何做会员排名 按照投稿文章数量

      

<table> <table> [e:loop={'SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news GROUP BY userid',10,24,0,'','total DESC'}] <tr> <td><?=$bqno?></td> <td><?=$bqr[username]?></td> <td><?=$bqr[total]?></td> </tr> [/e:loop] </table> 将上面的sql替换为以为sql语句就可以了

 

SELECTuserid,username,COUNT(userid)AStotal

FROM phome_ecms_news
GROUP BY userid
ORDER BY total DESC 
LIMIT 10 

转载于:https://www.cnblogs.com/liuye/archive/2013/01/15/2860740.html