用:select * from phome_enewsad where adid in (广告ID1,广告ID2,....)
实例:
[e:loop={"select * from phome_enewsad where adid in (1,2,3) and t=0 order by adid desc……
软件总下载数: <?=$empire->gettotal("select sum(totaldown) as total from phome_ecms_download")?>文章总浏览数:
<?=$empire->gettotal("select sum(onclick) as total from phome_ecms_news")?>……
帝国CMS任意模板中调用留言,可只调用已审核的留言,也可不限制是否审核。代码如下:<?
//bid为留言分类ID,checked='0' 0为已审核,1为未审核
$sql=$empire->query("select * from {$dbtbpre}enewsgbook where bid='1' and ch……
如题,会员空间反馈信息调用。代码如下:<?
//会员空间反馈 调用
//userid='1' 会员ID
$sql=$empire->query("select ftext,uname,uid from {$dbtbpre}enewsmemberfeedback where userid='1' order by fid desc limit 8")……
SQL: select a.id,a.classid,a.title,a.titlepic,a.username,a.userid,a.applynum,a.onclick,a.titleurl,b.id,b.classid,count(b.id) fromphome_ecms_news as a left join……