帝国cms 随机调取新闻

<?php
$hits_r = $empire->query("select * from {$dbtbpre}ecms_music as t1 join (select round(rand() * ((select max(id) from {$dbtbpre}ecms_music)-(select min(id) from {$dbtbpre}ecms_music))+(select min(id) from {$dbtbpre}ecms_music)) as id) as t2  where t1.id >= t2.id and t1.classid = {$GLOBALS['navclassid']} order by t1.id limit 10"); //查询新闻表最新10条记录
$i==0;
while($r=$empire->fetch($hits_r)) //循环获取查询记录
{
    $titleurl=sys_ReturnBqTitleLink($r); //标题链接
    $i++;
?>
<li class="<?=$i?>"><a href="<?=$titleurl?>" title="<?=$r['title']?>"><?=$r['title']?></a></li>
<?php
}
$empire->free($hits_r);
?>

 

转载于:https://www.cnblogs.com/yuesha/p/10277090.html