So, I have a site with a products section, a product_type section, and a product_color section. The product_type and product_color sections have a "title" field and uploaded "graphic" field. This way the client can add/delete/modify types of products and offered colors on-the-fly, via CMSB, and the products section records will be automatically updated because inside each products record are the fields "product_color" and "product_type" which dynamically populate from their respective tables.
What I'm wanting to do for the client is have a list page of product types (producttypes.php) in which each product type hyperlinks to the products list page (products.php) that only displays the list records with that specific product type. Then when one of those links is chosen it brings up the selected product detail page (productsDetail.php).
So, the producttypes.php might have listings for types: bowls, vases, lamps, stemware. When the visitor chooses a category from this page, say "stemware" they get the products list page (products.php) but only shows the listings for products in the database that have stemware chosen in their product_type field. Then they select a single product, say 'champagne glass' from the products list page for just stemware and get the Details for that product (productDetails.php?champagne-13). Make sense?
I've performed similar operations in the past, but for the life of me I am unable to figure out how to set up the 2 list pages properly. What goes in the header, and what goes in the body to make this work?
Thanks!