帝国cms模板里调用前台会员名及投稿数量排名的代码
以下是调用代码:会员投稿新闻数据表的排行榜
- <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>
查看更多 帝国cms教程 帝国cms模板