帝国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(newstime, '%Y%m%d' ))=curdate()