以下代码加到帝国cms模板里面,比如首页模板ul[e:loop={select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 8,10,24,0}]lia href=/e/space/us
$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 * from (select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime unionselect id,clasid,titleurl,filename,title
代码如下:[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
$members=$empiregettotal("select count(*) as total from phome_enewsmember");$newmember=$empirefetch1("select userid,username from phome_enewsmember order by userid desc limit 1");会员总人数:=$members最