Re: SQL field problem
| From: | Rick Emery | Date: | Wed, 10 Jul 2002 18:26:34 +0000 |
| Subject: | Re: SQL field problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-106911@lists.php.net to get a copy of this message | ||
SELECT DISTINCT kat FROM mytable;
---- Original Message -----
From: <mail@struempf.com>
To: <php-general@lists.php.net>
Sent: Wednesday, July 10, 2002 12:40 PM
Subject: [PHP] SQL field problem
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