帝国cms灵动标签调用指定某个时间段发布的内容

指定某个时间段的内容

1、某天发布的文章


[e:loop={'news',10,18,0,'newstime>='.to_time('2010-11-11 00:00:01').' and newstime<='.to_time('2010-11-11 23:59:59').''}]
<a href="" target="_blank">
[/e:loop]

或 (to_time 换成  to_date)


[e:loop={'news',10,18,0,'newstime>='.to_date('2016-07-31 00:00:01').' and newstime<='.to_date('2016-08-31 23:59:59').''}]
<a href="" target="_blank">
[/e:loop]

2、某一段时间发布的文章


[e:loop={'news',10,18,0,'newstime>='.to_time('2016-07-31 00:00:01').' and newstime<='.to_time('2016-08-31 23:59:59').''}]
<a href="" target="_blank">
[/e:loop]

或 


[e:loop={"select * from [!db.pre!]ecms_news where newstime > UNIX_TIMESTAMP('2016-06-01') and newstime < UNIX_TIMESTAMP('2016-08-23')  order by id desc limit 30",30,24,0}]
  • <a href="" target="_blank">
  • [/e:loop]

    发表回复

    您的电子邮箱地址不会被公开。 必填项已用*标注