select怎样 将两个数据分别写入两个字段.
<select name="pxid">
<%dim nrs
set nrs=server.createobject("adodb.recordset")
nrs.open"select * from news_class",dbconn,1,1
do while not nrs.eof
%>
<option selected value="<%=nrs("pxid")%>"><%=nrs("classname")%></option>
<%nrs.movenext
loop
nrs.close
set nrs=nothing%></select>
<%dim nrs
set nrs=server.createobject("adodb.recordset")
nrs.open"select * from news_class",dbconn,1,1
do while not nrs.eof
%>
<option selected value="<%=nrs("pxid")%>"><%=nrs("classname")%></option>
<%nrs.movenext
loop
nrs.close
set nrs=nothing%></select>
我现在只能把PXID写入数据库pxid字段。想把classname写入classname字段。请问怎么才能实现??