<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={SQL Server};Database=a;Server=a;uid=**;pwd=**"
set rs=server.CreateObject("adodb.recordset")
sql="select * from a"
rs.open sql,conn,1,1
if rs.eof then
rs.addnew
name=request("")
rs.update
end if
do while not rs.eof
name=rs("name")
rs.movenext
loop
%>
<select>
<opiton>
</select>
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={SQL Server};Database=a;Server=a;uid=**;pwd=**"
set rs=server.CreateObject("adodb.recordset")
sql="select * from a"
rs.open sql,conn,1,1
if rs.eof then
rs.addnew
name=request("")
rs.update
end if
do while not rs.eof
name=rs("name")
rs.movenext
loop
%>
<select>
<opiton>
</select>
function typeChange(n)
{
var length = document.form1.elements[n+1].options.length;
for(var i=0;i<length;i++)
{
document.form1.elements[n+1].options.remove(0);
}
var optionText = new Array(22);
var zifuLink = new Array(22);
var optionValue = new Array(22);<? optFill();?>
var typeID = document.form1.elements[n].value;
var newElem = document.createElement("OPTION");
newElem.text = "请选择……";
newElem.value = "";
document.form1.elements[n+1].options.add(newElem);
for(i=0;i<numrows;i++)
{
if(zifuLink[i] == typeID)//($rs[f_city] == typeID)
{ var newElem = document.createElement("OPTION");
newElem.text = optionText[i];
newElem.value = optionValue[i];
document.form1.elements[n+1].options.add(newElem);
}
}
}
</script>
<form name="form1">
大类<select name="et" id="select25" onChange="typeChange(0)">
</select>
大类下所属小类
<select name="prolb" id="select26">
</select>
</form>
从数据库中自己检索你的大类别
--------------------------
用模板就可以轻松实现
有意思
$sql="select a_name,a_value form a_table";
.....
echo "<select name='name'>
while($row=mysql_fetch_array($result)){
echo "<option value=".$row[a_value].">".$row[a_name]."</option>";
}
echo "</select>";
?>