a Count() ?
| From: | Dave Carrera | Date: | Sat, 16 Mar 2002 10:46:38 +0000 |
| Subject: | a Count() ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17707@lists.php.net to get a copy of this message | ||
Hi All
I am trying to count how many product names in my db have the same
category id and then show it ie:
Catid 1 Product 1
Catid 1 Product 2
Catid 2 Product 3
Catid 3 Product 4
Catid 3 Product 5
Result would be
Catid1 has 2 products
Catid2 has 1 products
Catid3 has 2 products
I think it has something to do with the GROUP command but the mysql doc
dose not make it clear how to achive this task.
Code examples, pointers to web resources or any info thankfully
received.
Thank you in advance
Dave Carrera
Php Developer
http://davecarrera.freelancers.net
http://www.davecarrera.com