帝国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 } ?>