高效率随机调用:
<?php
$num=$empire->num("select ta gid from {$dbtbpre}enewsta gs");
$randnum=100;
$randids='';
$randdh='';
for($i=1;$i<=$randnum;$i++)
{
$randids.=$randdh.rand(1,$num);
$randdh=',';
}
?>
[e:loop={"select ta gname,ta gid from phome_enewsta gs where ta gid in ($randids) limit $randnum",32,24,0}]
<a target="_blank" href="/ta g/<?=$bqr['ta gid']?>/" title="<?=$bqr['ta gname']?>"><?=$bqr['ta gname']?></a> |
[/e:loop]
代码这里,修改url以及样式即可使用,随机高效率代码
正常调用:
[e:loop={"select ta gname,ta gid from phome_enewsta gs limit 12 ",32,24,0}]
<a target="_blank" href="/e/ta gs/?ta gname=<?=$bqr['ta gname']?>" title="<?=$bqr['ta gname']?>"><?=$bqr['ta gname']?></a> |
[/e:loop]
随机调用:
[e:loop={"select ta gname,ta gid from phome_enewsta gs order by rand() limit 12 ",32,24,0}]
<a target="_blank" href="/e/ta gs/?ta gname=<?=$bqr['ta gname']?>" title="<?=$bqr['ta gname']?>"><?=$bqr['ta gname']?></a> |
[/e:loop]
内 容页调用:
[e:loop={"select a.*,b.* from [!db.pre!]enewsta gs a LEFT JOIN [!db.pre!]enewsta gsdata b ON a.ta gid=b.ta gid where b.classid='$navinfor[classid]' and b.id='$navinfor[id]' group by b.ta gid order by a.num desc limit 10",0,24,0}]
<a href='<?=$public_r['newsurl']?>e/ta gs/?ta gname=<?=$bqr['ta gname']?>' title='<?=$bqr['num']?>个'><?=$bqr['ta gname']?>(<?=$bqr['num']?>)</a>
[/e:loop]
发表评论