精華 帝國PHP系統靈動標簽調用昨天發布的10篇文章

                        <p>昨天發布的10篇文章</p>

<?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?>、<a href="<?=$bqsr['titleurl']?>"?target="_blank"><?=$bqr['title']?></a><?=date('Y-m-d',$bqr[newstime])?> <br>
[/e:loop]