亚洲视频二区_亚洲欧洲日本天天堂在线观看_日韩一区二区在线观看_中文字幕不卡一区

將以下代碼加到首頁模板里面

<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>

注：調(diào)用的是會員組id為1的會員發(fā)布的新聞數(shù)據(jù)表數(shù)量排序