I am developing an e-commerce site with a mySQL backend.
The client will manage the db by adding categories and items.
I'd like to be able to create a single include file which will allow for a menu creation regardless of new categories or items added.
The current page is at http://18.104.22.168/~redtrail/
What I want to to replace the text "Products" with "Categories". When you expand categories you'll see what is currently listed. Then I want to be able to expand each category to see a listing of items in that category.
My DB structture is as follows:
I have attached the structure of my Categories and Products tables.
In the products table there is a field called "ProdCategories". This is what category(ies) and item should be under. Where thee is more than one, it is a pipe-separated list (1|3|20).
How can I write a query to group the products by category and then create the menu?