Re: records in db
| From: | Analysis & Solutions | Date: | Sat, 10 Aug 2002 20:46:41 +0000 |
| Subject: | Re: records in db | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111981@lists.php.net to get a copy of this message | ||
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
--Dan
--
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