for the drop down list:
<form>
<select Name="Artist">
<option selected>Choose Artist</option>
<%
Dim rs2, MYSQL2
set c = server.createobject ("ADODB.connection")
set rs2 = server.createobject ("ADODB.recordset")
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("./DBFolder/DB.mdb")
MYSQL2 = "SELECT Artist, COUNT(Artist) AS majorCategories "
MYSQL2 = MYSQL2 & "FROM TableName GROUP BY Artist ORDER BY Artist;"
rs2.open MYSQL2, c, 1, 3
While Not rs2.EOF
%>
<option value="<%= rs2("Artist") %>"><%= rs2("Artist") %></option>
<%
rs2.MoveNext
Wend
rs2.close
c.close
%>
</select>
this may help.
Edited by zMaestro
Topic Options
Post Options
Thanks(0)
