Creating a Category List and Results
Hi, I am trying to create a "Buyer's Guide". The first page - buyersguide.php will have a drop down menu that is populated with the categories (advertising, accounting, construction, etc.) from the table Categories. Once the user selects the category they are interested in, it will take them to a results page (buyersguideresults.php) that will list all Members who fit into the category they choose.
So, I have 3 tables:
1. Members:
MemberID, CompanyName, Phone, TollFree, Fax, Address, City, State, Zip, Website, Descriptions, Email
2. MemberCategory:
MemberCategoryID, f_MemberID, f_CategoryID
3. Categories:
CategoryID, CategoryName
First off, after I populate the drop down menu - how do I get it to take you to the results page. Once on the results page, how do I show the members info for the selected category?
Please help! I've been working on this for weeks and just can't seem to get it! Thanks!