程序如下所示,在指定需要读取的父栏目后,就可以把这个栏目下的所有子栏目(包括一级栏目和二级栏目同时同时调取出来了,很方便,简单易用)
下面贴出代码,希望能帮助有需要的朋友~
<?php$ecms_bq_sql=sys_ReturnEcmsLoopBq("select * from [!db.pre!]enewsclass where bclassid=58 order by myorder limit 7",14,24,0);$bqno=0;while($bqr=$empire->fetch($ecms_bq_sql)){ $bqsr=sys_ReturnEcmsLoopStext($bqr); $bqno++; ?> <li><a href='<?=$public_r[newsurl]?><?=$bqr[classpath]?>/'><?=sub($bqr[classname],0,54,false)?></a><p><?php $ecms_bq_sql2=sys_ReturnEcmsLoopBq("select * from [!db.pre!]enewsclass where bclassid=$bqr[classid] order by myorder limit 8",14,24,0); $bqno2=0; while($bqr2=$empire->fetch($ecms_bq_sql2)) { $bqsr2=sys_ReturnEcmsLoopStext($bqr2); $bqno2++; ?> <a href="<?=$public_r[newsurl]?><?=$bqr2[classpath]?>/" ><?=sub($bqr2[classname],0,54,false)?></a> <?php } ?></p></li> <?php}?>
发表评论: