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.... >Next question.... >How can I show how many of each there were? >SO now I have > >breafast >lunch >dinner > >I want to have > >breafast 2 >lunch 3 >dinner 3 > >etc... >is that just as easy? > > > > > > > >[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; > > > > > > [EMAIL PROTECTED] > sungard.com To: php- >[EMAIL PROTECTED] > > cc: > 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 >theunit? > >EG: > >Unit item >breakfast cereal >breakfast toast >lunch salad >lunch sandwich >dinner steak >dinner pie >lunch soup >dinner lasagne > >and so on.. >I'd wanna get a list of: >breafast >lunch >dinner > >not several instances of each... >how can I do this? > >********************************************************************* >The information contained in this e-mail message is intended only for >the personal and confidential use of the recipient(s) named above. >If the reader of this message is not the intended recipient or an agent >responsible for delivering it to the intended recipient, you are hereby >notified that you have received this document in error and that any >review, dissemination, distribution, or copying of this message is >strictly prohibited. If you have received this communication in error, >please notify us immediately by e-mail, and delete the original >message.*************************************************************** ******** > > > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > >********************************************************************* >The information contained in this e-mail message is intended only >for >the personal and confidential use of the recipient(s) named above. >If the reader of this message is not the intended recipient or an agent >responsible for delivering it to the intended recipient, you are >hereby >notified that you have received this document in error and that any >review, dissemination, distribution, or copying of this message is >strictly prohibited. If you have received this communication in >error, >please notify us immediately by e-mail, and delete the original >message.*************************************************************** ******** > ></SPAN> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php