• Home
 · 
• Active Server Pages
 · 
• 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

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

• 1
• 2
• 3
• 4
• 5

(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>