帝國CMS高級應用—靈動標簽調用二級導航 循環子欄目和信息:

<div class="nav"><div class="nav">    <div class="nav-inner">      <div class="clearfix nav-inner" id="menu">        <ul class="navlist">          <li><a href="[!---news.url--]"><span>網站首頁</span></a></li><!-- class="current"-->[e:loop={"select classid,classname,islast,sonclass from {$dbtbpre}enewsclass where bclassid='0' order by myorder,classid ASC limit 11",0,24,0}]<?php$classurl=sys_ReturnBqClassname($bqr,9); //取得欄目地址$tbname=$class_r[$bqr[classid]][tbname]; //取得表名$navshow=ReturnClassAddField($bqr[classid],'nav'); //取得欄目自定義字段navshow值?>          <li><a href="<?=$classurl?>" target="_blank"><span><?=$bqr[classname]?></span></a><?php//值為0時顯示二級，值為1時不顯示二級if(!$navshow){        //終極欄目Start        if(!$bqr[islast])        {                //判斷是否有子欄目Start                if($bqr[sonclass])                {                        echo '<ul>';                        //循環欄目下的子欄目Start                              $newsclass=$empire->query("select classid,classname from ".$dbtbpre."enewsclass where bclassid=".$bqr[classid]." order by myorder,classid desc limit 10");                        while($classr=$empire->fetch($newsclass)) {                        $classrurl=sys_ReturnBqClassname($classr,9); //取得子欄目地址                        ?>                        <li><a href="<?=$classrurl?>"><?=$classr[classname]?></a></li>                        <?php            }                        //循環欄目下的子欄目End                  echo '</ul>';        }        //判斷是否有子欄目End    }    //終極欄目End    else        //非終極欄目Start     {                $numinfo=$empire->gettotal("select count(*) as total from ".$dbtbpre."ecms_".$tbname." where classid=".$bqr[classid]); //統計子欄目信息        //判斷終極欄目下是否有信息Start                if($numinfo)        {                        echo '<ul>';            //循環欄目下的信息Start            $newsinfo=$empire->query("select title,id,classid,newspath,filename,groupid,titleurl from ".$dbtbpre."ecms_".$tbname." where classid=".$bqr[classid]." order by newstime desc limit 10");            while($infor=$empire->fetch($newsinfo)) {            $titleurl=sys_ReturnBqTitleLink($infor);            ?>                                                <li><a href="<?=$titleurl?>"><?=$infor[title]?></a></li>                        <?php            }            //循環欄目下的信息End            echo '</ul>';        }        //判斷終極欄目下是否有信息End    }        //非終極欄目End }?>          </li>[/e:loop]        </ul>      </div>    </div>  </div>