帝国CMS SQL调用当天发布的最新内容信息

<?php
$timedays = strtotime(date("Y-m-d", time()));
$timedaye = $timedays + 3600 * 24;
$r = $empire->query('select id, title, titleurl from ' . $dbtbpre . 'ecms_news where newstime >= ' . $timedays . ' and newstime <= ' . $timedaye . ' order by newstime desc limit 10');
while ($row = $empire->fetch($r)) {
?>
<li><a href="<?php echo $row[titleurl]; ?>"><?php echo $row[title]; ?></a></li>
<?php
}
?>