帝国cms使用sql语句列出栏目

<?php

            $sql=$empire->query("select * from {$dbtbpre}enewsclass where  bclassid = '0' and showclass = '0' order by myorder,classid asc");

while($rclass=$empire->fetch($sql))

{

?>

            <li class="dropdown active">

                <a class="dropdown-toggle" data-toggle="dropdown" href="<?=$rclass[listdt]?"/e/action/ListInfo/?classid=".$rclass[classid]:"/".$rclass[classpath]."/"?>"><?=$rclass[classname]?><b class="caret"></b></a>

                <?php

                if($rclass[islast]==0){

?>

                <ul class="dropdown-menu">

                <?php

$sql2=$empire->query("select * from {$dbtbpre}enewsclass where  bclassid = '$rclass[classid]' and showclass = '0' order by myorder,classid asc");

while($rclass_son=$empire->fetch($sql2))

{

?>

                    <li><a href="<?=$rclass_son[listdt]?"/e/action/ListInfo/?classid=".$rclass_son[classid]:"/".$rclass_son[classpath]."/"?>"><?=$rclass_son[classname]?></a></li>

                <?php

}

?>

                </ul>

                <?php

}

?>

            </li>

            <?php

}

?>