1、调用会员发布文章数table[e:loop={SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc,0,24,0}]trtd=$bqno/tdtd=$bqr[username]
在需要显示的页面模板里面添加以下代码$bclasid=$GLOBALS[navclasid]; 取得本栏目id取得本栏目下的子栏目[e:loop={select clasid,clasname,maxnum,claspath from [!db.pre!]enewsclas where bclasid=206 order by my
将以下代码加到首页模板里面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 u