SELECT DISTINCT kat FROM tablename; should work. Martin
>>> <[EMAIL PROTECTED]> 07/10/02 01:40PM >>> Hello I have a problem with mysql.I create a table with a field "kat".In this field are entries like this : Light Dark Dark Light Robot Find Dark Light You see that all entries are not unique.So i want to list as output all entries but only once.If the word "Dark" is in the table 6 times php should output dark only 1 time. How should i solve this problem ? Thanks! chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php