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

[La Verkin]

第一步要知道如何用mysql操作数据库调用随机文章标题， 这么实现：
SELECT id, title,titleurl FROM phome_ecms_news WHERE id >= ((SELECT MAX(id) FROM phome_ecms_news)-(SELECT MIN(id) FROM phome_ecms_news)) * RAND() + (SELECT MIN(id) FROM phome_ecms_news) ORDER BY id LIMIT 10

再将上边的语句整合到灵动标签：
[e:loop={'SELECT id, title,titleurl FROM [!db.pre!]ecms_news WHERE id >= ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news)) * RAND() + (SELECT MIN(id) FROM [!db.pre!]ecms_news) ORDER BY id LIMIT 10',10,24,0}]
<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
[/e:loop]