Chris, select distinct kat from tablename;
Its in the mysql manual, 6.4.1 SELECT Syntax. HTH Chris [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