I think you want to use group by: SELECT * FROM table GROUP BY kat; -- Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com
On Wed, 10 Jul 2002 19:40:11 +0200 <[EMAIL PROTECTED]> wrote: > 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