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

Reply via email to