灵动标签操作数据库调用随机文章标题

[La Verkin]

下边的效果更好:

SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10

整合到灵动标签中：

<ul>
[e:loop={'SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10 ',10,24,0}]
<li><a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a></li>
[/e:loop]
</ul>