帝国CMS自定义列表调用当天发布的信息统计：select count(*) as total from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newstime, '%Y%m%d' ))=curdate()查询：select * from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newst…
统计记录: select count(*) as total from [!db.pre!]ecms_movie查询记录: select * from [!db.pre!]ecms_movie order by id desc注释：[!db.pre!]ecms_movie 为数据表类型（movie是电影数据表）desc - 降序排列 ASC - 升序排列id desc 是按id降序排…
