[RESOLVED] Display total records query

[regkapur]

In my database I have 5 Fields (Prod_id...Category_id...Subcategory...Product_Name...Product...Image)

What I would like to do is show the total number of records in 'Category_id'

For example, if I have 25 products in 'Category_id' with an id of '1' and 30 with an id of '2' I would like to display the relevant numbers ie 25 & 30.

Make sense? :bemused:

Thanks for your help in advance.

[bogu]

SELECT Category_id, COUNT(Prod_id) as nr FROM `table`
GROUP BY Category_id

I think this should do ...

[regkapur]

Yep. worked fine. Just needed to change a field (had put the wrong field in question) Doh.

Thanks