Here is my problem, I have a mysql database with about 33,000 records or so. In field "a" there is a list of names full of duplicates ( which is fine ). What I would like to do is display the list of names in a drop down form, but want the names to only show up once not a million times.
Example : Lets say I have a name Robert Smith in field "a", the name Robet Smith is listed 20 times in that field because he put out 20 hits or what ever. Now I want to allow a user to select Robert Smith from a drop down form so that we can refine the search to just hits by just him.
I know how to produce the select form from the database, but can't seem to get it to display just once. Any help would be greatly appreciated.
Regards