jodbowrs Posted November 16, 2011 Share Posted November 16, 2011 I was using Coldfusion in Dreamweaver and recently switched to PHP so I'm new at this. my goal: to have just one page that will display a list of members (we're a non-profit assoc) based off the link clicked. the links are fields of work that are separate fields in the database. If someone does work in that field then a 1 is placed in that field for that record. They are allowed to do work in more than one field. So... I would like to find a way to set up the links with a variable or parameter so that when you click "Builders & Contractors" it will take you to the 1 directory page which would then pull up anyone who has a 1 in the "Builders_Contractors" field. The only way that I have figured out how to make this work is to create a separate page for each category with the query set to pull up the appropriate list. Please help! We have over 100 fields of work plus a page for each letter of the alphabet! That's way too many pages to have all separately. Link to comment https://forums.phpfreaks.com/topic/251268-new-to-php-link-to-a-page-that-will-display-dynamic-data-based-off-link/ Share on other sites More sharing options...
fenway Posted November 16, 2011 Share Posted November 16, 2011 Your DB design is already flawed -- you have tribbles. Link to comment https://forums.phpfreaks.com/topic/251268-new-to-php-link-to-a-page-that-will-display-dynamic-data-based-off-link/#findComment-1288748 Share on other sites More sharing options...
jodbowrs Posted November 16, 2011 Author Share Posted November 16, 2011 You have a suggestion for a better way to do it? I'm self trained and figuring this out as I go. As far as the rules go, I have no code to post since I'm asking if there's a way to do this. I'm sorry but I'm at a loss and just need some direction. Link to comment https://forums.phpfreaks.com/topic/251268-new-to-php-link-to-a-page-that-will-display-dynamic-data-based-off-link/#findComment-1288750 Share on other sites More sharing options...
fenway Posted November 16, 2011 Share Posted November 16, 2011 Well, virtual page design is a subject for the php help forum. But if you want to store multiple categories for a given link, you'll need another table. Link to comment https://forums.phpfreaks.com/topic/251268-new-to-php-link-to-a-page-that-will-display-dynamic-data-based-off-link/#findComment-1288768 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.