代码如下:最新会员SQL:select a.userid,a.username,b.userpic as titlepic from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid order b...
帝国CMS调用评论列表查询代码$totalquery="select count(*) as total from {$dbtbpre}enewspl_1 where username='$user[username]'".$a;
$num=$empire->gettotal($...
<table>
[e:loop={'SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news GROUP BY userid',10,24,0,'','total DESC'}]
<tr>...