<script language="JavaScript">
function AddItemCity(seSelect)
{
<%
'城市
Set rs=Server.CreateObject("ADODB.Recordset")
strSql="SELECT * FROM 城市"
rs.Open strSql, conn, 1, 1
for i=1 to rs.recordcount
%>
seSelect.add(new Option("<%=rs(0)%>","<%=rs(1)%>"));
<%
rs.MoveNext
next
rs.close
%>
}
function sprice(seSelect,val)
{
s=seSelect.length;
for (i = 0; i < s; i ++)
seSelect.options[0]=null;
seSelect.add(new Option("所有区县","所有区县"));
<%
'城市
Set rs=Server.CreateObject("ADODB.Recordset")
Set rsType=Server.CreateObject("ADODB.Recordset")
strSql="SELECT * FROM 城市"
rs.Open strSql, conn, 1, 1
for i=1 to rs.recordcount
%>
if (val=='<%=rs(0)%>')
{
<%
'区县
strSql="SELECT * FROM 区县 WHERE PID='" & rs(0) & "'"
rsType.Open strSql, conn, 1, 1
for j=1 to rsType.recordcount
%>
seSelect.add(new Option("<%=rsType(0)%>","<%=rsType(2)%>"));
<%
rsType.MoveNext
next
rsType.close
%>
}
<%
rs.MoveNext
next
rs.close
%>
}
AddItemCity(form1.City);
sprice(form1.Area,'');
</script>