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
ðÒÉ×ÅÔ!
[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
:)
ÐÏËÁ
áÌØÂÅÒÔÏ
ëÉ
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 t
message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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:
ssage
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
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
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
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 &quo
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
9 matches
Mail list logo
