beezo Posted February 7, 2007 Share Posted February 7, 2007 I have a simple mySQL DB that contains addresses- In Dreamweaver I inserted a list menu that is populated dynamically w/ all the cities on the list via PHP. What I am trying to do is have each city listed only once in the list menu w/ out repeats. In other words, say I have a city that is listed 20 times on my DB. In the dynamic list menu, I want the city only listed one time...I have been puzzeling over this all day. Any help would be appreciated. Thanks, B Quote Link to comment Share on other sites More sharing options...
beermaker74 Posted February 7, 2007 Share Posted February 7, 2007 in your sql query use distinct http://www.webdevelopersnotes.com/tutorials/sql/online_mysql_guide_the_distinct_keyword.php3 that should solve your problem Quote Link to comment Share on other sites More sharing options...
beezo Posted February 7, 2007 Author Share Posted February 7, 2007 Thanks for taking the time to reply to my post w/ a solution. I really appreciate it. Take care, -B Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.