I need to create a list of products, grouped by a category field. I am using PHP and MySQL. I have fields called ProdName, ProdCat etc.
I need the list to appear as follows:
- Category A
- Product 1
- Product 2
- Category B
- Product 3
- Product 4
- Product 5
- Category C
- Product 6
I want to create a product listing which lists ALL products but groups by category, with each Category to appear in it's own styled div.
I would also like to have a drop down list at the top of the page which would give the user an option to view products which just appear in particular section (i.e. only show products from Category B)
Any help would be greatly appreciated.