New to PHP - link to a page that will display dynamic data based off link

[jodbowrs]

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.

[fenway]

Your DB design is already flawed -- you have tribbles.

[jodbowrs]

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.

[fenway]

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.