My word, easy when you know how...!
Cheers mate!!!
[EMAIL PROTECTED]
07/08/2003 14:42
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: [PHP-DB] Breaking down a table field
SELECT DISTINCT(Unit) from TABLE_NAME
SELECT DISTINCT unit...
Ignatius
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 07, 2003 3:37 PM
Subject: [PHP-DB] Breaking down a table field
> I have a table, wth many entries.
> Each entr
SELECT Unit,COUNT(Unit) as quantity FROM TABLE GROUP BY Unit
-- Oscar Satorre Pérez [EMAIL PROTECTED] --
- Mensaje Original -
Remitente: [EMAIL PROTECTED]
Destinatario: [EMAIL PROTECTED]
Fecha: Jueves, Agosto 7, 2003 3:52pm
Asunto: Re: [PHP-DB] Breaking down a table field
:
08/07/2003 09:37 AM Subject: [PHP-DB] Breaking down a
table field
I have a table, wth many entries.
Each entry has been asigned a unit to belong to.
I want to list all the units dynamically.
How can I display all the units, without displaying each instance of the
unit?
EG:
Unititem
breakfast cereal
breakfast toa
: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: [PHP-DB] Breaking down a table field
SELECT DISTINCT(Unit) from TABLE_NAME;
[EMAIL PROTECTED]
sungard.com To: [EMAIL PROTECTED
: [EMAIL PROTECTED]
Subject:Re: [PHP-DB] Breaking down a table field
SELECT DISTINCT(Unit) from TABLE_NAME;
[EMAIL PROTECTED]
sungard.com To: [EMAIL PROTECTED
]
08/07/2003 09:52 AM Subject: Re: [PHP-DB] Breaking down
a table field
