banacan Posted February 1, 2008 Share Posted February 1, 2008 Hi All, I'm creating a dynamic website with a products table. Each record has fields to distinguish the product by category, group, type, etc. I want to create one products page to display the products, but I need to select them based on one or more of the distinguishing fields. I have created the site navigation (SPRY horizontal drop-down) for the purpose of selecting products based on their distinguishing features, e.g. Fruits & Vegetables > Fruits > Melons. What I need to know is how do I make the navigation link open the products.php page and show only the products that match those criteria, in the above example, Melons. Do I need to create a recordset (Melons, etc.) for each possible search criteria and reference that in the navigation link? Or can I use one general recordset, which contains all of the fields I may need to search, that can somehow be limited through the navigation link? It seems to me that having as many recordsets in a page as there are choices, would be unwieldy and needlessly complex. How is this normally handled? And how would it be done using DWCS3? Many many thanks. Quote Link to comment https://forums.phpfreaks.com/topic/88906-solved-help-struggling-to-understand-navigation-based-record-selection/ Share on other sites More sharing options...
banacan Posted February 3, 2008 Author Share Posted February 3, 2008 Solved thanks to Thorpe in this post. http://www.phpfreaks.com/forums/index.php/topic,179142.0.html Quote Link to comment https://forums.phpfreaks.com/topic/88906-solved-help-struggling-to-understand-navigation-based-record-selection/#findComment-456790 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.