Well ulthane has provided the conditional logic to do the trick but we need to know which city we are viewing... Have you passed that through a querystring argument or is it an ID that we pull from the database?
Originally Posted by smita86
Assuming we know what city we are viewing and put that value in a variable called varCity You need to use it in your code as follows:
varCity = 'The city we're looking at
varSelected = "" 'This is just the string we use to bookmark the drop down
<%while not rs.EOF%>
if varCity = rs(0) then
varSelected = "selected = ""selected"""
<option <%=varSelected%> value=<%=rs(0)%>><%=rs(0)%></option>
varSelected = ""