帝国ECMS教程:SQL语句调用栏目导航

核心提示：<table width="200" border="0" cellpadding="3" cellspacing="1" bgcolor="#4FB4DE">< tr>< td heigh

<table width="200" border="0" cellpadding="3" cellspacing="1" bgcolor="#4FB4DE">
< tr>
< td height="25"><strong><font color="#FFFFFF">栏目导航</font></strong></td>
< /tr> 
[e:loop={"select classid,classname from {$dbtbpre}enewsclass where bclassid=父栏目id order by myorder,classid desc",0,24,0}]
< ?php
$classurl=sys_ReturnBqClassname($bqr,9);//取得栏目地址
$bgcolor="#FFFFFF";
if($bqr[classid]==$GLOBALS[navclassid])//当前栏目ID
{
$bgcolor="#C3EFFF";
} 
?>
< tr>
< td height="25" bgcolor="<?=$bgcolor?>"><a href="<?=$classurl?>"><?=$bqr[classname]?></a></td>
< /tr>
[/e:loop]
< /table>

 

例三：灵动标签显示一级栏目导航，且在子栏目时也给当前一级栏目的背景设为蓝色

<table width="200" border="0" cellpadding="3" cellspacing="1" bgcolor="#4FB4DE">
< tr>
< td height="25"><strong><font color="#FFFFFF">栏目导航</font></strong></td>
< /tr> 
[e:loop={"select classid,classname from {$dbtbpre}enewsclass where bclassid=0 order by myorder,classid desc",0,24,0}]