将以下代码加到首页模板里面

<table>   
[e:loop={'SELECT news . * FROM phome_enewsmember member INNER JOIN (SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news WHERE ismember =1 GROUP BY userid)news WHERE member.userid = news.userid',10,24,0,'','total DESC'}]   
<tr>   
<td><?=$bqno?></td>   
<td><?=$bqr[username]?></td>   
<td><?=$bqr[total]?></td>   
</tr>   
[/e:loop]   
</table>

注:调用的是会员组id为1的会员发布的新闻数据表数量排序

声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。