科讯获取当前一级栏目下 二级栏目嵌套 三级栏目sql调用
以上代码供参考,实际应用请自行更改
科讯获取当前栏目二级栏目sql 语句
select ClassID,ID,FolderName,TN from KS_Class where TN=(SELECT mid(TS,1,14) as TS from KS_Class where ID='{#CurrClassID}') order by folderorder
二级栏目循环体
[loop=9]
<li><a href="{$Field(ID,GetInfoUrl,100,1)}" >
{$Field(FolderName,Text,0,...,0,)}</a>{SQL_三级栏目({$Field(ID,Text,0,...,0,)})}
</li>
[/loop]
三级栏目sql
SELECT TOP 20 ID,FolderName,TN FROM KS_Class Where Tn='{$Param(0)}' and TopFlag=1 order by folderorder
三级栏目循环体
[loop=20]
<li><a href="{$Field(ID,GetInfoUrl,100,1)}">{$Field(FolderName,Text,0,...,0,)}</a></li>
[/loop]
以上代码供参考,实际应用请自行更改