统计记录:select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie查询记录:select clasid,id,titleurl,title,newstime from [!db.pre!]ecm
$members=$empiregettotal(select count(*) as total from phome_enewsmember);$newmember=$empirefetch1(select userid,username from phome_enewsmember order by userid desc limit 1);$tzcount=$empiregettotal(
[e:loop={"SELECT * , COUNT(bm) AS num FROM cmsmoban_ecms_shop GROUP BY bm ORDER BY num DESC LIMIT 10",10,24,0}]li=$bqr[num] em=$bqr[bm]/em/li[/e:loop]bm就是我们新建的自定义字段,根据bm字段内容的多