昨天发布的10篇文章 <?php $beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y')); $endYesterday=mktime(0,0,0,date('m'),date('d'),date('Y'))-1; ?> [e:loop={"select * from [!db.pre!]ecms_news where newstime BETWEEN $beginYesterday and $endYesterday order by newstime desc limit 10",0,24,0}] <?=$bqno?>、<?=$bqr['title']?><?=date('Y-m-d',$bqr[newstime])?>
[/e:loop]
调用2016-08-01的10篇文章 [e:loop={'news',10,18,0,'newstime>='.to_time('2016-08-01 00:00:01').' and newstime<='.to_time('2016-08-01 23:59:59')}] <?=$bqr[title]?>