Re: SQL field problem
| From: | Tyler Longren | Date: | Wed, 10 Jul 2002 17:45:09 +0000 |
| Subject: | Re: SQL field problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-106897@lists.php.net to get a copy of this message | ||
I think you want to use group by:
SELECT * FROM table GROUP BY kat;
--
Tyler Longren
Captain Jack Communications
tyler@captainjack.com
www.captainjack.com
On Wed, 10 Jul 2002 19:40:11 +0200
<mail@struempf.com> 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
>