【帝国CMS】灵动标签随机调取文章

【帝国CMS】灵动标签随机调取文章

[e:loop={"select * from {$dbtbpre}ecms_sitenav order by rand() desc limit 6",20,24,0}]
<div class="col-12 col-md-6 col-lg-4">
<div class="ho-hotsitenav">
<em><a href="<?=$bqsr['titleurl']?>" rel="nofollow"><img src="<?=$bqr[titlepic]?>" class="img-fluid" alt="<?=$bqr['title']?>"></a></em>
<span>
<strong><a href="<?=$bqsr['titleurl']?>" rel="nofollow"><?=$bqr['title']?></a></strong>
<p><?=$bqr['smalltext']?></p>
</span>
</div>
</div>
[/e:loop]

{$dbtbpre}ecms_sitenav   数据表

order by rand()   随机

limit 6   数量