<%
set db=server.createobject("adodb.recordset")
sql="select distinct yuming from RegistTable"
db.open sql,cnn,1,1
if not db.eof then
%>
<%
i=0
do while not db.eof
%>
<option value="<%=db("yuming")%>" style="background-color:#e8f0ff"><%=db("yuming")%></option>
<%
db.movenext
i=i+1
loop
%>
</select>
</td>
</tr>
<%
end if
db.close
set db=nothing
cnn.close
set cnn=nothing
%>