Pulling unique data from database
| From: | Richard Kurth | Date: | Mon, 02 Feb 2004 02:26:50 +0000 |
| Subject: | Pulling unique data from database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-176545@lists.php.net to get a copy of this message | ||
I am pulling data from a database that list the Language a person
speaks. It is in a format like this.
English||Spanish
English
English||Portuguese||Finnish
English||Japanese||German
English
English
German
each time it looks at a new record it list all the languages that that
person speaks with a double pipe in between each language.
What I need to do is find all the unique languages so I can generate a
list of languages that do not have any repeats in it. so the list above
would be English,Portuguese,Finnish,Japanese,German,Spanish in any
order
How would I go about this. I can not change the format of the database
and there are over 200 people listed in the database.