利用帝国cms灵动标签调用SQL语句写法

不醉不来 2018-7-2 533

[e:loop={"select id,classid,newspath,filename,groupid,titleurl from [!db.pre!]ecms_".$class_r[$navinfor['classid']]['tbname']." where id>=(SELECT floor(RAND() * (SELECT MAX(id) FROM [!db.pre!]ecms_".$class_r[$navinfor['classid']]['tbname']."))) and classid=".$navinfor['classid']." and id=".$navinfor['id']." order by id desc limit 7",7,24,0}]
<a rel="nofollow" href="<?=$bqsr['titleurl']?>" class="white"><?=$bqno?></a>
[/e:loop]


最新回复 (0)
返回
发新帖