On Sat, Aug 10, 2002 at 05:52:42PM +0000, Tyler Durdin wrote:

> If I have a field in my DB that can have 4 different answers, lets say 
> a,b,c and d. How can I count the number of each in that field. So if there 
> are 4 a's 1 b 0 c's and 12 d's how can I get php to count this?

Us the database to do that:

   SELECT FieldName, count(*) FROM TableName GROUP BY FieldName


               PHP classes that make web design easier
        SQL Solution  |   Layout Solution   |  Form Solution
    sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to