Another Looping Query containg Drop Down List
Posted on 2003-10-29
I have a database which holds frequently asked questions. There are basically four fields:
ID, CATEGORY, QUESTION, ANSWER
To make it easier for people to search for these questions I would like to set out the FAQs page as follows:
Drop down list containing all of the questions for CATEGORY1.
Drop down list containing all of the questions for CATEGORY2
CATEGORY3, etc, etc...
I would like each drop downlist links to a separate page which holds all the answers for that category.
Each question on the answer page will have it's own anchor named with the ID from the database. So by clicking on the question from the dropdown list the user goes straight to the answer.
I hope this is clear in principle. Can anyone help me put this into action?
Thanks in advance.