View Single Post
  #1   IP: 49.87.51.184
Old 2015-10-06, 11:41 AM
East Canton East Canton is offline
初级会员
 
Join Date: 2012-06-12
Posts: 2
East Canton 现在声名狼藉
Default 调用顶级栏目下文章

1 如只调用10个顶级栏目, 每个栏目调用2篇文章:
Code:
[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篇文章:
Code:
[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]
Reply With Quote