MySQL的一级分类_【求助】点击二级分类时只显示一级分类对应的二级分类

[0], subcat[2]);

}

}

}

sql = "select * from jle_class1 order by Class1Sort asc"

rsa.open sql,conn,1,1

if rsa.eof and rsa.bof then

response.write "请先添加栏目。"

response.end

else

%>

一级分类

%>

" selected>

rsa.movenext

loop

end if

rsa.close

%>

二级分类

* 地区：全市区

set rsCity=server.createobject("adodb.recordset")

sqlc="select * from jle_area order by AreaSort asc"

rsCity.open sqlc,connstr,1,1

do while not rsCity.eof

%>

" selected>

rsCity.movenext

loop

%>

set rsCity=nothing

%>

信息标题：">

*

联系人：

" type="text" size="16" maxlength="20">

电话：">

QQ：" type="text" size="16" maxlength="15">

Email:" type="text" size="30" maxlength="300">

联系地址：" type="text" size="40" maxlength="40">

name=ID>

文章内容： 图片地址： ">

set rs=nothing

End Sub

%>