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
比如招聘和求职,企业会员只出招聘,普通会员只出求职$modsql=$empirequery(select mid,qmname from {$dbtbpre}enewsmod where usemod=0 and showmod=0 and qenter order by myorder,mid);while($modr=$empirefetch($mod