SELECT DISTINCT kat FROM mytable;
---- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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