帝国cms 灵动标签高效调用数据表随机数据

02-03 编辑:青岛网站建设
示例:
[e:loop={"SELECT * FROM `[!db.pre!]ecms_news` AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM `[!db.pre!]ecms_news`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id ASC LIMIT 10",10,24,0}]

<li><a href="<?=$bqsr['titleurl']?>" target="_blank" title="<?=$bqr['title']?>"><?=$bqr['title']?></a></li>

[/e:loop]
 
本站文章均为智慧.半岛网站建设摘自权威资料,书籍,或网络原创文章,如有版权纠纷或者违规问题,请即刻联系我们删除,我们欢迎您分享,引用和转载,我们谢绝直接复制和抄袭!感谢...
我们猜你喜欢