I <think> you may already have this, but just another 20 pesos.... SELECT Unit, COUNT(Unit) [Quantity] FROM <table> GROUP BY Unit -----Original Message----- From: Tristan.Pretty@risk.sungard.com [mailto:Tristan.Pretty@risk.sungard.com] Sent: Thursday, August 07, 2003 8:52 AM To: jeffrey_n_Dyke@Keane.com Cc: php-db@lists.php.net Subject: Re: 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? jeffrey_n_Dyke@Keane.com 07/08/2003 14:42 To: Tristan.Pretty@risk.sungard.com cc: php-db@lists.php.net Subject: Re: Breaking down a table field.... SELECT DISTINCT(Unit) from TABLE_NAME; Tristan.Pretty@risk. sungard.com To: php-db@lists.php.net cc: 08/07/2003 09:37 AM Subject: 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: 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. *********************************************************************** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
