试一试这个:
-----------------
<form name="searching">
<SELECT NAME="sort" onchange="shows(smallsort,sort);"><option value="">公司名称</option><option value="1">公司名称1</option><option value="2">公司名称2</option><option value="3">公司名称3</option>
</select>
<SELECT name="smallsort" style="display:inline;" ><option value="">公司人员1</option><option value="1">王</option><option value="2">阿斯蒂芬</option><option value="3">阿斯蒂芬</option><option value="4">洒的发</option><option value="56">其他</option>
</SELECT><SELECT name="smallsort" style="display:none;" ><option value="">公司人员2</option><option value="6">阿斯蒂芬</option><option value="7">阿斯蒂芬</option><option value="8">阿三点</option><option value="9">阿斯蒂芬</option><option value="57">其他</option>
</SELECT><SELECT name="smallsort" style="display:none;" ><option value="">公司人员3</option><option value="14">阿斯蒂芬</option><option value="15">斯蒂芬</option><option value="16">大幅度</option><option value="17">进口量进口</option>
<option value="29">其他人</option>
</SELECT>
</form>
<script>
function shows(smallsort,sort)
{
var a;
a=document.searching.sort.selectedIndex;
if(a==0)return;document.searching.smallsort[0].style.display='none';document.searching.smallsort[1].style.display='none';document.searching.smallsort[2].style.display='none';document.searching.smallsort[a-1].style.display='inline';
}
</script>
-----------------
-----------------
<form name="searching">
<SELECT NAME="sort" onchange="shows(smallsort,sort);"><option value="">公司名称</option><option value="1">公司名称1</option><option value="2">公司名称2</option><option value="3">公司名称3</option>
</select>
<SELECT name="smallsort" style="display:inline;" ><option value="">公司人员1</option><option value="1">王</option><option value="2">阿斯蒂芬</option><option value="3">阿斯蒂芬</option><option value="4">洒的发</option><option value="56">其他</option>
</SELECT><SELECT name="smallsort" style="display:none;" ><option value="">公司人员2</option><option value="6">阿斯蒂芬</option><option value="7">阿斯蒂芬</option><option value="8">阿三点</option><option value="9">阿斯蒂芬</option><option value="57">其他</option>
</SELECT><SELECT name="smallsort" style="display:none;" ><option value="">公司人员3</option><option value="14">阿斯蒂芬</option><option value="15">斯蒂芬</option><option value="16">大幅度</option><option value="17">进口量进口</option>
<option value="29">其他人</option>
</SELECT>
</form>
<script>
function shows(smallsort,sort)
{
var a;
a=document.searching.sort.selectedIndex;
if(a==0)return;document.searching.smallsort[0].style.display='none';document.searching.smallsort[1].style.display='none';document.searching.smallsort[2].style.display='none';document.searching.smallsort[a-1].style.display='inline';
}
</script>
-----------------
---------------<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "driver={SQL Server};server=(local);uid=sa;pwd=;database=dbname"
dim req;
req=request("sort");
if req-1=0 then
sql="select user from table where company='公司一'"
set rs=conn.execute(sql)
tempstr="<select name="select1" value="">"
while not rs.eof
tempstr=tempstr &"<option value='" & rs("user") & "'>"& rs("user")&"</option>"
rs.movenext
wend
elseif req-2=0 then
sql="select user from table where company='公司一'"
set rs=conn.execute(sql)
tempstr="<select name="select1" value="">"
while not rs.eof
tempstr=tempstr &"<option value='" & rs("user") & "'>"& rs("user")&"</option>"
rs.movenext
wend
elseif req-3=0 then
sql="select user from table where company='公司一'"
set rs=conn.execute(sql)
tempstr="<select name="select1" value="">"
while not rs.eof
tempstr=tempstr &"<option value='" & rs("user") & "'>"& rs("user")&"</option>"
rs.movenext
wend
else
response.write "错误请求"
end if
%>
<form name="searching">
<select name="sort" onchange="f2()">
<option value="">公司名称</option><option value="1">公司名称1</option><option value="2">公司名称2</option><option value="3">公司名称3</option></select>
<%=tempstr%>
</form>
<script>
function f2(){
var vr=document.searching.sort.value;
alert(vr);
document.location.href="11.asp?sort="+vr;
}
</script>