科訊獲取當(dāng)前一級(jí)欄目下 二級(jí)欄目嵌套 三級(jí)欄目sql調(diào)用
以上代碼供參考，實(shí)際應(yīng)用請(qǐng)自行更改
科訊獲取當(dāng)前欄目二級(jí)欄目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
二級(jí)欄目循環(huán)體
[loop=9]
<li><a href="{$Field(ID,GetInfoUrl,100,1)}" >
{$Field(FolderName,Text,0,...,0,)}</a>{SQL_三級(jí)欄目({$Field(ID,Text,0,...,0,)})}
</li>
[/loop]
三級(jí)欄目sql
SELECT TOP 20 ID,FolderName,TN FROM KS_Class Where Tn='{$Param(0)}' and TopFlag=1 order by folderorder
三級(jí)欄目循環(huán)體
[loop=20]
<li><a href="{$Field(ID,GetInfoUrl,100,1)}">{$Field(FolderName,Text,0,...,0,)}</a></li>
[/loop]
以上代碼供參考，實(shí)際應(yīng)用請(qǐng)自行更改