I need to create a list of links that will be generated from a database search where users have entered in their types of business. Of course some users will have identical businesses and I only want the list to display one of each – no duplicates. So let’s say there’s 5 people and two are plumbers, I want the display list to only show one value of plumber.
I was going to have the database structured like this:
id | customer name | type of business|
The type of business will be numerical, generated from a list that will be on a drop down form that they will fill out. 1 = painter, 2 = plumber, 3 = electrician, etc…
So for this loop, how do I make it so it will only display the trade once and not three or four or a dozen times?? I just want to show that out of this group of people, this trade is at least one of their businesses.
Thanks in advance ?