A little problem with database tables.

[baisern]

Hi, guys!!!

I making a test for my students.
I have some tables that I would like to connect, but I don't know how. This is how I want the test to run: When the students log in, they have to select a subject and then a chapter. After this, a selection of questions will appear, blablabla...
The real problem is how to keep the subject and the chapter, like a header! Then I can work with questions and alternatives later.

Thank you...

[Anon]

Hallo there;

I don't know wether I have understood your point or not:

The Students select Subject and Chapter from option box: Drop Down menu.

if you generate the Subject and the Chapter from the database dynamically,

<form action = file.php method=post>";
<select name = SubjectID>";
$query = "select * from subject where ...";
$result = mysql_query($query);
while($record = mysql_fetch_object($result)){
if($record->SubjectID == $SubjectID){$sel = "Selected";}
if($record->SubjectID != $SubjectID){$sel = "";}
echo "<option value= '$record->SubjectID' $sel>$record->SubjectName</option>";
}
echo "</select>";
......

This keeps the selected subject as a header,