Displaying dynamic form elements from database

Hello all. So this is a bit of a complicated problem which i will attempt to explain (I have tried a couple of times but perhaps didn't phrase it correctly).

What I am creating is a dynamic feedback form, for rating lecturers who teach classes. What I need to do (see picture1) is for each class (when user selects it) a form needs to be dynamically created which displays a variable number of questions from a database. Here is an example:

--------------------------------
How did you rate the teaching?

Lecturer name 1                             (drop down box where a rating can be selected)
Lecturer name 2                                   "                                                    "
Lecturer name 3                                   "                                                    "

the amount of lecturers and questions can vary depending on the module, won't be more than six of wither though...So this will be looped through as in the picture
------------------------------------

What I understand is that this would be some sort of nested loop (see the code below and picture2). The code I have below displays only one question and lumps all the ratings into one box. It also doesn't display the lecturers (can't work out how to add this in) so is definitely wrong.

Here are the tables I have, I will try and explain how they relate to each other:

Survey  // this is essentially the feedback form
 SurveyID (PK)
 ModuleID (FK) // links to the modules table
 SurveyDate

SurveyQuestion // links the survey to question database
  qsID (PK)
  SurveyID (FK)
  QuestionID (FK)

Question
  QuestionID (PK)
  QuestionType // Two types, rating and text (only concerned by rating)
  QuestionText

QuestionRating // links questions to rating scale name (drop down lists)
  QuestionRating (PK)
  QuestionID (FK)
  ratingID (FK)

RatingName // this isn't actually needed in the design, the next table is the important one
  ratingID (PK)
  RatingName (FK)

RatingScale // this is what populates the drop down list
  rsID (PK)
  ratingID (FK)
  ratingValue // e.g 1, 2, 3, 4, 5 or Great, Good, Ok, Weak, Rubbish.

Modules
  moduleID (PK)
  module_name
  description

Modules_Lecturers
  mIID (PK)
  moduleID (FK)
  lecturerID (FK) // links to lecturers table

Lecturer
  lecturerID
  leader_fname
  leader_Sname

I realise this looks complicated but thought it was important to give the full table structure..

When the form is submitted the date is going to go into this table:

FeedbackRating
  FeedRating
  SurveyID
  LecturerID
  RatingValue

So does anyone know how to do this? I will be incredibly grateful for any help.

$query = "SELECT SurveyQuestion.QuestionID, QuestionText
                                FROM SurveyQuestion, Question
                                WHERE SurveyID = '$surveyID'
                                AND Question.QuestionID = SurveyQuestion.QuestionID
                                AND Question.QuestionType = 'Rating'";
                                $result = mysql_query($query);
                                while ($question_rec = mysql_fetch_assoc($result)) {
                                  
                                  print "Q: {$question_rec['QuestionText']}<br>\n";
                                  
                                  #guessed this to some degree - may need to revise:
                                  $query = "SELECT DISTINCT RatingScale.ratingid, ratingValue
                                FROM RatingScale, QuestionRating, SurveyQuestion
                                WHERE RatingScale.ratingID = QuestionRating.ratingID
                                                                AND SurveyQuestion.QuestionID = {$question_rec['QuestionID']}";  #have assumed questionid is a numeric data type, or there would be quotes around the {} characters
                                  $result2 = mysql_query($query);
                                  print "<select name=\"q{$question_rec['QuestionID']}\"\n";
                                  while ($rating_rec = mysql_fetch_assoc($result2)) {
                                        print "<OPTION VALUE=\"{$rating_rec['ratingID']}\">{$rating_rec['ratingValue']}</OPTION>\n";
                                  }
                                  mysql_free_result($result2);
                                  print "</SELECT\n";
                                }

Select allOpen in new window

example4.jpg
example.jpg