UC知道关于二级联动的问题，我的怎么不对啊？我是从数据库读出的方法
来源：百度知道 编辑：UC知道 时间：2024/05/22 14:38:10
<% set rs=server.createobject("adodb.recordset")
sql="select * from diz where sheng<>'""'"
rs.open sql,conn,1,1
%>
<tr>
<th scope="row">省份：</th>
<td><select name="sheng" size="1" value="<%=rs("sheng")%>">
<% do while not rs.eof %>
<option><%=rs("sheng")%></option>
<% dim shengji
shengji=rs("sheng") %>
<%rs.movenext
loop%>
</select>
</td>
</tr>
<% set rs1=server.createobject("adodb.recordset")
sql1="select * from diz where sshi='"&rs("sheng")&"'"
rs1.open sql1,conn,1,1
%>
<tr>
<th scope="row">市：</th>
<td><select name=&q
sql="select * from diz where sheng<>'""'"
rs.open sql,conn,1,1
%>
<tr>
<th scope="row">省份：</th>
<td><select name="sheng" size="1" value="<%=rs("sheng")%>">
<% do while not rs.eof %>
<option><%=rs("sheng")%></option>
<% dim shengji
shengji=rs("sheng") %>
<%rs.movenext
loop%>
</select>
</td>
</tr>
<% set rs1=server.createobject("adodb.recordset")
sql1="select * from diz where sshi='"&rs("sheng")&"'"
rs1.open sql1,conn,1,1
%>
<tr>
<th scope="row">市：</th>
<td><select name=&q
比较简单最主要的是javaScript函数
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<?
mysql_connect("localhost","root","");
mysql_select_db( "test" );
$sql = "select * from subject";
$result = mysql_query( $sql );
$count = 0;
while($res = mysql_fetch_row($result)){
?>
subcat[<?=$count?>] = new Array("<?=$res[0]?>","<?=$res[1]?>","<?=$res[2]?>");
<?
$count++;
}
echo "onecount=$count;";
?>
//联动函数
function changelocation(locationid)
{
document.myform.ctype.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][2] == locationid)
{
//var newOption1=new Option(subcat[i][1], subcat[i][