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

　2012-03-30 10:23:20　来源：WEB开发网　闂侀潧妫撮幏锟�

婵犫拃鍛粶闁靛洤娲ㄩ埀顒佺⊕閵囩偟绱為敓锟�闂侀潧妫撮幏锟�　　闂佺ǹ绻楀▍鏇㈠极閻愬搫绾ч柕濠忕細閼割亜顪冪€ｎ剙浠ф繛鍫熷灥椤曘儵顢欓悡搴ば�

核心提示：<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}]