Log in

View Full Version : 调用顶级栏目下文章


East Canton
2015-10-06, 11:41 AM
1 如只调用10个顶级栏目, 每个栏目调用2篇文章:

[e:loop={"select classid from [!db.pre!]enewsclass where bclassid=0 order by classid desc limit 10",0,24,0}]
<?php
$sql=$empire->query("select * from {$dbtbpre}ecms_news where classid='$bqr[classid]' limit 2");
while($r=$empire->fetch($sql))
{
echo '<a href="'.$r['titleurl'].'">'.$r['title'].'</a><br>';
}
?>
[/e:loop]


1 如调用所顶级栏目, 每个栏目调用2篇文章:

[e:loop={"select classid from [!db.pre!]enewsclass where bclassid=0 order by classid desc",0,24,0}]
<?php
$sql=$empire->query("select * from {$dbtbpre}ecms_news where classid='$bqr[classid]' limit 2");
while($r=$empire->fetch($sql))
{
echo '<a href="'.$r['titleurl'].'">'.$r['title'].'</a><br>';
}
?>
[/e:loop]