View Single Post
  #1   IP: 49.87.2.59
Old 2015-09-28, 11:02 PM
La Verkin La Verkin is offline
初级会员
 
Join Date: 2008-06-02
Posts: 2
La Verkin 现在声名狼藉
Default 灵动标签操作数据库调用随机文章标题

第一步要知道如何用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]
Reply With Quote