帝国cms调用一级栏目及下面的二级栏目调用方法如下:
SQL语句
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <code><?php $ecms_bq_sql =sys_ReturnEcmsLoopBq( "select * from [!db.pre!]enewsclass where bclassid=0 order by myorder limit 6" ,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> <div class = "head_nav_hover" > <?php $ecms_bq_sql2 =sys_ReturnEcmsLoopBq( "select * from [!db.pre!]enewsclass where bclassid=$bqr[classid] order by myorder limit 20" ,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 } ?> </div> </li> <?php } ?></code> |