How to Dynamically populate a menu item in a search form
Posted on 2006-10-25
Ok here's the situation I have thousands of property listings in my database and want to dynamically populate my search form dropdown menu with cities pulled from my database. The code I wrote below does that, but pulls the city from each row(thousands) so I have multiple duplicates of the same city name in my menu. How can I limit that to one instance of each city name? Hope this makes sense...Thanks!
<cfquery name="myqueryname" datasource="mydatasource">
SELECT col1, col5, col10, col15, col16
ORDER BY col10 ASC
<select name="col10" id="col10">
<cfoutput query = "myqueryname">