I have two tables one of exam with entries exam1, exam2.....and second table subjects which is connected with subject table. let physics, chemistry and mathematics are part of exam one . and English, Computers are part of exam 2. a form is created for asking doubts ,form has two dropdown (one for exam and other for subject)and one text field for typing doubt. dropdown menu connected with database.
.. now the problem is that when I select exam 2 from fom dropdown 1 subjects should be displayed automatically corresponding to that exam only but it is displaying same subjects irrespective selected exam. both dropdown menu are coonected with their respective tables.. subject displayed in second dropdown does not change with different. selection from first dropdown