我想读smallclass表中的smlaaclassname的数据在下拉条里!
我不知道怎么写?
大家帮忙!
请在下面的代码里改~谢谢!
<!--#include file="../conn.asp"-->
<%
sql= "select * from smallclass where bigclassname=公司分类 order by id desc "
rs.open sql ,conn, 1,1
%>
<form>
<select name="xssmallclassname">
<option value="<%rs="smallclassname"%>"></option>
</select>
</form>
<!--#include file="../conn.asp"-->
<%
sql= "select * from smallclass where bigclassname=公司分类 order by id desc "
rs.open sql ,conn, 1,3
%>
<form>
<select name="xssmallclassname">
<%while not rs.eof %>
<option value=<%=rs("smallclassname")%>><%=rs("smallclassname")%></option>
<%
rs.movenext
wend
%>
</select>
</form>