Re: [PHP] SQL field problem

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

Re: [PHP] SQL field problem

ðÒÉ×ÅÔ! [EMAIL PROTECTED] wrote: > 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 ? select distinct and RTFM :) ÐÏËÁ áÌØÂÅÒÔÏ ëÉ

Re: [PHP] SQL field problem

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

Re: [PHP] SQL field problem

Martin's post is what you want... knew there was a query (just couldn't remember it). "Chris Earle" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'd make another array that I can refer to and check for a value from the > original query (which with a huge ar

Re: [PHP] SQL field problem

I'd make another array that I can refer to and check for a value from the original query (which with a huge array could become cumbersome, but it doesn't look like you have will have too many duplicate names). Every time you come across a new value, add it to the 2nd array (if it's not new, then

Re: [PHP] SQL field problem

SELECT DISTINCT kat FROM tablename; should work. Martin >>> <[EMAIL PROTECTED]> 07/10/02 01:40PM >>> 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 uniqu

Re: [PHP] SQL field problem

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

RE: [PHP] SQL field problem

You can refer to fields by their number. $Row[3]; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:40 AM To: [EMAIL PROTECTED] Subject: [PHP] SQL field problem Hello I have a problem with mysql.I create a table with a field "kat".