调用表

因为做的，自定义列表比较多，现在想用自定义页面吧所有的列表调用出来。用灵动标签可以调用出列表的名字，但是连接无法调出解决方法：[e:loop={select *  from [!db.pre!]enewsuserlist,20,24,0}]a href==($bqr[filepath])

[e:loop={"select * from phome_enewszt where clasid='$GLOBALS[navclasid]'",10,24,0}]a href="/=$bqr[ztpath]" target="_blank"=$bqr[ztname]/a[/e:loop]调用本栏目所属专题

列表内容模板(list.var)代码：$uid=$empirefetch1(select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]});$usql=$empirefetch1(select * from {$dbtbpre}enewsmember where userid = {$r[userid]});$use

新增自定义列表页：查询SQL语句:统计记录:select count(*) as total from [!db.pre!]enewsmember查询记录:select u.*,ui.* from [!db.pre!]enewsmember u LEFT JOIN [!db.pre!]enewsmemberadd ui ON u.userid=ui.useri

灵动标签调用多个数据表信息的方法如下：[e:loop={select * from (select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime unionselect id,clasid,titleurl,filename,title

帝国CMS没有通用的调用网站栏目名称的标签，!pagetitle]是调用当前页面的名称如果想在列表页或者内容页调用网站的名称可以使用：=$public_r[sitename]

代码如下：[e:loop={select * from phome_enewszt where clasid=3 order by ztid desc,10,24,0}]li clas=nopicspan=format_datetime($bqr[addtime],md)/spana href==$bqr[ztpath] title==$bqr[ztname]=$bqr[ztname]/a/

效果图如下：把以下代码加到内容页模板里即可 $userr=sys_ShowMemberInfo(0,); span clas=udate注册时间：=$userr[registertime]==null:date(md,$userr[registertime])/span span clas=udate会员积分：=$userr[userfe

select userid,count(*)as myorder from phome_ecms_photo group by userid order by myorder desc

调用会员在某个数据表发帖量的排行，没有发布信息的会员按照会员ID排序sql：select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group

调用会员在某个数据表发帖量的排行，没有发布信息的会员按照会员ID排序代码如下：select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember

代码如下：[e:loop={select * from ( select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime union select id,clasid,titleurl,filename,title,newstime,titlepic from ph