以下代码适合放到封面模板,列表模板和内容页模板$clas_sql=$empirefetch1('select clasid,clasname,bname from '.$dbtbpre.'enewsclas where clasid='.$GLOBALS[navclasid].'');$bname=$clas_sql[bname];
新增自定义列表页:查询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
会员空间模板支持用php查询所有表,例子:会员空间的留言用这个调用:$gbsql=$empirequery(select gid,isprivate,uid,uname,ip,addtime,gbtext,retext from {$dbtbpre}enewsmembergbook where userid=$userid order by gid
灵动标签调用多个数据表信息的方法如下:[e:loop={select * from (select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime unionselect id,clasid,titleurl,filename,title
内容页模板加入以下代码[e:loop={'select ztid from phome_enewsztinfo where clasid='.$navinfor[clasid].' and id='.$navinfor[id],10,24,0}] 所属专题: a href="/=$clas_zr[$bqr[ztid]][ztpath]"=$clas_zr[$bqr[zt