<?
$sql=$empire->query("select classid,classname,infos from {$dbtbpre}enewsclass where bclassid=0 and showclass=0 order by myorder,classid asc");
$bqno=0; while($bqr=$empire->fetch($sql)){
$bqsr=sys_ReturnEcmsLoopStext($bqr);
$bqno++;?><!-- 大栏目名 --><?=$bqr[classname]?> <!-- 大栏目信息数 --><?=$bqr[infos]?>
<?
$sql2=$empire->query("select classid,classname,infos from {$dbtbpre}enewsclass where bclassid=$bqr[classid] and showclass=0 order by myorder,classid asc"); while($bqr2=$empire->fetch($sql2)){
$bqsr2=sys_ReturnEcmsLoopStext($bqr2); ?>
<!-- 小栏目名 -->
<?=$bqr2[classname]?>
<!-- 小栏目信息数 -->
<?=$bqr2[infos]?>
<!-- 子栏目信息列表，不需要就删除 -->
<ul>
<?
$sql3=$empire->query("select title,titleurl,newstime from {$dbtbpre}ecms_news where classid=$bqr2[classid] order by id desc limit 10"); while($bqr3=$empire->fetch($sql3)){
$bqsr3=sys_ReturnEcmsLoopStext($bqr3); ?>
<span><?=date('m-d',$bqr3[newstime])?></span><a href="<?=$bqr3[titleurl]?>" target="_blank" title="<?=$bqr3[title]?>"><?=esub($bqr3[title],36)?>...</a>
<?
} ?>
</ul>
<?
} ?>
<!-- 子栏目信息列表，不需要就删除 --><?
}?>可以显示指定表名，如news表
select classid,classname,infos from {$dbtbpre}enewsclass where bclassid=0 and showclass=0 and tbname='news' order by myorder,classid asc
0 评论