统计记录:select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie查询记录:select clasid,id,titleurl,title,newstime from [!db.pre!]ecm
新增自定义列表页:查询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
后台 其他管理 增加自定义列表按照要求填,到 查询SQL语句 部分统计记录: select count(*) as total from phome_enewszt 查询记录: select ztname as title,ztpath as newspath,ztimg as titlepic,intro as smallte
用自定义列表实现可分页的DIGG排行,统计记录默认即可,数据库的查询记录如下。DIGG排行查询记录:select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc点击排行查询记录:select * from [!db.pre!]ecm