Filling form select with non-duplicate data.
Posted: Fri Nov 01, 2002 9:09 pm
Okay, if I got you this far by just the subject I must be going down the right path
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
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