How to view my database table in my dropdownbox

[iniyan]

hi guys need help again!!!! i want to retrieve data from the database table and put inside my drop down box.For example i want to view all my products example
F216,F217,F218 in my dropdown box.how to do that?How to view all data in column in my dropdownbox.

[jhardman]

The basic idea:[code=asp]rs.open "SELECT productID FROM dbTable", conn
response.write "<select>"
do until rs.eof
response.write "<option>" & rs("productID" ) & "</option>" & vbNewLine
rs.movenext
loop
response.write "</select>" & vbNewLine[/code]