帝国CMS教程：自定义列表sql语句调用当天发布的信息！

自定义列表调用当天发布的信息

统计：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(newstime, '%Y%m%d' ))=curdate()