Products Table:
ID, Name, CatID
Categories:
ID, CatName
Products List:
1 , Iphone, 1
2, Samung s3, 1
3, Mac book , 2
4, Apple Headphone, 3
Categories:
1, Mobiles
2, Laptop
3, Headsets
So as above Records lets say i want to display:
No of Mobiles:
No of laptops:
No of Headsets: