php SQL输出某栏目下的一级栏目
$class_sql=$empire->query("select classid,classname,bname from {$dbtbpre}enewsclass where bclassid=1 order by myorder");
while($class_row=$empire->fetch($class_sql)){
?>
=$class_row['classname']?>}
?>
php SQL输出某栏目下的信息
$xinxi_sql = $empire->query("select id,title,titleurl from {$dbtbpre}ecms_news where classid=1 order by newstime limit 10");
while($xinxi_row=$empire->fetch($xinxi_sql)){
?>
=$xinxi_row['title']?>}
?>
以上两个例子自行发挥。比如栏目链接地址可以根据需求获取伪静态地址或者静态地址以及动态地址。自己根据需求更改即可。
$class_sql = $empire->query("select classid,classname,bname from {$dbtbpre}enewsclass where bclassid=1 order by myorder");
while ($class_row = $empire->fetch($class_sql)) {
$classurl = sys_ReturnBqClassUrl($class_r[$class_row['classid']]);
?>
=$class_row['classname'] ?>}
?>