php to database using multiple drop downs

[vinylblare]

can someone help me. i want to access data in a database but by using 3 drop downs.

how can i do this. i want a student to be able to select coursename, year of study and semester and when they click submit the available modules will be displayed.

please email me if you can help. i'll give you a list of all my tables etc.
thankyou

[svnfightsvn]

in your code, query the database and output each row as a select option.

$query = "select course_id, course_name from courses";

print "<select>";
....get_results and loop through them....
{
  print "<option value=$course_id>$course_name</option>";


}
print "</select>";

of course, this is very simplified