<!--#include file="conn.asp"-->
<%
dim provinceId,cityId
provinceId=Request.Form("provinceId")
cityId=Request.Form("cityId")


if provinceId<>"" then
Response.Write "<option value='0'>请选择</option>"
set rsClass2=server.CreateObject("adodb.recordset")
sqlClass2="select * from com_china where LevelID=1 and parentid="&provinceId&" order by id asc"
rsClass2.open sqlClass2,conn,1,1
do while not rsClass2.eof
%>
<option value='<%=rsClass2("id")%>'><%=rsClass2("name")%></option>
<%
rsClass2.movenext
loop
rsClass2.close
end if


if cityId<>"" then
Response.Write "<option value='0'>请选择</option>"
set rsClass2=server.CreateObject("adodb.recordset")
sqlClass2="select * from com_china where LevelID=2 and parentid="&cityId&" order by id asc"
rsClass2.open sqlClass2,conn,1,1
do while not rsClass2.eof
%>
<option value='<%=rsClass2("id")%>'><%=rsClass2("name")%></option>
<%
rsClass2.movenext
loop
rsClass2.close
end if
%>