Im struggling to work out how to set up TWO dropdown menus that consist of the same information - in this case football managers names.
The reason I need two dropdown menus is so users to my site can choose TWO different peoples names (one from each menu) and they will be given the statistics of those people so they can be compared.
I run a non-league football (soccer) website and I am trying to allow visitors the opportunity to look at individual `past` managers and compare them to one-another. ie, games managed, won, lost etc etc.
I can do it with ONE dropdown but cannot find anywhere which shows how to set up TWO dropdowns and then drag the info from a database?
strSql = "SELECT <<BLAH>> FROM <<TABLE>>"
set rs = Server.CreateObject("ADODB.Recordset")
rsUser.open strSqlUser, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
recCount = ""
else
allData = rs.GetRows(adGetRowsRest)
recCount = UBound(allData,2)
end if
rs.close
set rs = nothing
if recCount <> "" then
Response.Write "<select name=""<<name here>>"">"
for x = 0 to recCount
Response.Write "<option value =""" & allData(0,x) & """>" & allData(0,x) &"</option>"
next
Response.Write "</select>"
Response.Write "<select name=""<<name here>>2"">"
for x = 0 to recCount
Response.Write "<option value =""" & allData(0,x) & """>" & allData(0,x) &"</option>"
next
Response.Write "</select>"
else
Response.Write "NO <<BLAH>> FOUND!"
end if
This isn't perfect as one can select the same person but I'm sure someone know the javascript to change that.
But to code the back end we would need to know a little more how your db is set up and what you want.
Topic Locked
Posted - 20 April 2008 : 08:04:07
