select cat_id, count(prod_id) from some_table order by cat_id; Best regards,
Andrey Hristov ----- Original Message ----- From: "Dave Carrera" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 16, 2002 12:46 PM Subject: [PHP-DB] a Count() ? > 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php