Populates a drop down menu from the contents of a table in a database
Populates a drop down menu from the contents of a table in a database
Rate Populates a drop down menu from the contents of a table in a database
(3(3 Vote))
<option value="0">Any</option>
<%
sql="SELECT * FROM CarMakes Order By Make"
set recordset=conn.execute(sql)' starts a connection to the database
do while not recordset.eof ' cycles through the contents of the table
response.Write("<option value=" & recordset("ID") & " >" & recordset("Make") & " </option>") ' creates an option from the database
recordset.movenext
loop
%>
</select>
Populates a drop down menu from the contents of a table in a database Comments
No comments yet — be the first to post one!
Post a Comment