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 Link to comment https://forums.phpfreaks.com/topic/37406-solved-phpdreamweaver-dynamic-list-menu/ 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 Link to comment https://forums.phpfreaks.com/topic/37406-solved-phpdreamweaver-dynamic-list-menu/#findComment-178935 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 Link to comment https://forums.phpfreaks.com/topic/37406-solved-phpdreamweaver-dynamic-list-menu/#findComment-179236 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.