How to include a specific form based on a record field?

[lneal]

Hi - I have a newbie question, not sure if I am going about this the right way...

I'm creating a web interface in Dreamweaver CS3, using PHP and MySQL. We are tracking different types of activities, and based on the activity type, the user has to answer a series of questions (different questions for each activity type).

I have the following tables set up:

ACTIVITIES
- activityID
- activityTypeID
- activityName
- activityDescription

ACTIVITY_TYPES
- activityTypeID
- activityTypeName

ACTIVITY_QUESTIONS
- activityQid
- activityTypeID
- questionText

ACTIVITY_ANSWERS
- activityAid
- activityID
- activityQid
- answerText

I have a detail page that displays info about a selected activity (activity name, type, description). I would like to display the questions form on this page, based on the activity type. What is the best way to do this?

Thanks so much!

[TheServant]

Welcome to Bytes.
I think that what you want is MySQL JOIN. Have a look at that if haven't already and come back with any questions or give an example of what you want.

A more detailed example of a few more MySQL techniques are avaiable here to help you on your travels.

[TheServant]

After reading your question again, I think maybe this is qhat you want:

SELECT activity_types.activityTypeName, activity_questions.activityQid, activity_questions.questionText
FROM activity_types, activity_questions
WHERE activity_types.activityTypeID = activity_questions.activityTypeID

That should get you started as it will fetch the questions associated with each activity by matching TypeID's. After you get that under control, then you can be more specific in your WHERE clause and include a "AND activity_types.activityTypeID = '$selected' " or something like that to select specific ones.

Hope that helps.