Question

asp循环怎么做

数据库结构是这样的
id sid name
1 0 1级栏目名称
2 1 2级栏目名称
3 2 3级栏目名称
4 3 4级栏目名称
。。。。。。。
无限级的，假设传过来的id是1，如何根据sid取得所有子栏目的ID？

Answer 1

<%
function fl(navsid,rootid)
set rs1 =server.createobject("adodb.recordset")
sql="select * from navigation where navsid="&navsid&" order by navsort asc"
'rs1.open sql,conn,1,1
set rs1=conn.execute(sql)
If rs1.eof Then
Else
do while not rs1.eof
id = rs1("id")

if rs1("navsid").value=9 then
response.write " var mytree" & rs1("id").value & "=mytree.addChild('" & rs1("title").value & "','"&rs1("link")&"','','',false,true);" & vbcrlf
else
response.write " var mytree" & rs1("id").value & "=mytree" & rs1("navsid") & ".addChild('" & rs1("title").value & "','"&rs1("link")&"','','',false,true);" & vbcrlf
end if

sql2="select * from navigation where navsid="&navsid&" order by navsort asc"
set rs2=server.createobject("adodb.recordset")
set rs2=conn.execute(sql2)
if not rs2.eof then
call fl(id,rootid)
end if
rs2.close
set rs2=nothing
rs1.movenext
loop
End If
rs1.close
set rs1=nothing
end function
%>

Answer 2

你 的id 和sid 啥关系哟 没关系的东西如何联系在一起