Gettting records inside select box

sureshkbk · #1 (**permalink**) 01-23-04, 00:45

I need to load a field retrieved from a database into a select box. How can i do it. I need the code.

rhs98 · #2 (**permalink**) 01-23-04, 07:09

You mean you need to populate a select box with values from a database?

sureshkbk · #3 (**permalink**) 01-23-04, 10:01

Yes, I need to populate the select with the content of a database

rhs98 · #4 (**permalink**) 01-23-04, 10:19

Code:

'open rs
%>
<select name="selecty thing">
<%
while not rs.eof
%>
<option value="<%=rs.fields("id")%>"><%=rs.fields("text")%></option>
<%
rs.movenext
wend
%>
</select>
<%
'close rs

Internet Services

Web Development

Digital Marketing

Consumer Tech