How can I create a drop-down list using the database content?

How can I create a drop-down list using the database content?

<% MyDSN = "DSN = xur; uid = xur; pwd = xur"
MySQL = "select * from authors where AU_ID <100"
Set conntemp = server. createobject ("adodb. connection ")
Conntemp. open myDSN
Set rstemp1_conntemp.exe cute (mySQL)
If rstemp. eof then
Response. write"Oh,The database is empty.! "
Response. write mySQL
Conntemp. close
Set conntemp = nothing
Response. end
　End if %>
<% Do until rstemp. eof %>
<%
Rstemp. movenext
Loop
Rstemp. close
Set rstemp = nothing
Conntemp. close
Set conntemp = nothing

'Clear objects
%>