: Re: [PHP-DB] Breaking down a table field
Next question
How can I show how many of each there were?
SO now I have
breafast
lunch
dinner
I want to have
breafast2
lunch 3
dinner 3
etc...
is that just as easy?
[EMAIL PROTECTED]
07/08/2003 14:42
SELECT DISTINCT(Unit) from TABLE_NAME;
[EMAIL PROTECTED]
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
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 entry has been asigned a unit
]
08/07/2003 09:52 AM Subject: Re: [PHP-DB] Breaking down
a table field