php similar records count?

W

wissi

New member
Hello, I have a mysql db and that have multiple category records like Animals. Automobiles, Food etc...

On the web page, I want to display each category with its number of records using PHP same like in the example below:

- Animals (8)
+ Cats (2)
+ Dogs (3)
+ Rats (3)

- Automobiles (7)
+ Toyota (4)
+ Suzuki (2)
+ Mercedez (1)

- Food (3)
+ Burgers (1)
+ Vegetables (2)

Remember one thing that I have coded all PHP codes using Dreamweaver CS3 and I have not wrote any code myself. Plz also guide me according to Dreamweaver coding style. this will more helpful

Thanks
pls provide code manually (not DW codeing style).

My DB has following tables

tbl_products
id
title
category
details

tbl_category
id
c_title

thanks
 
Back
Top