灵动标签调用多个数据表信息的方法如下:[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 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/
后台 其他管理 增加自定义列表按照要求填,到 查询SQL语句 部分统计记录: select count(*) as total from phome_enewszt 查询记录: select ztname as title,ztpath as newspath,ztimg as titlepic,intro as smallte
调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员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