i have a table in Mysql's database, tblStudents, which has 1,000 stdents, from different departments, e.g 500 from IIT, 300 from IMS, 100 from Medical, 100 from Engineering.

and on fornt end in, i have 2 dropdown boxes, one drpdwnDown box is filled with values, IMS, IIT, MEDICAL, ENGINEERING. now i want to fill 2nd dropdown box on basis of 1st drop down box selection mean if i click IMS from 1st dropdown box then 2nd dropdown box should be filled with all students roll no., from IMS or if i click IIT then 2nd dropdown box should be filled with all students' roll no.s from IIT,
from database it should pck value.

i spent 2 days on it but couldn't solve it, plz help me with it


4 Years
Discussion Span
Last Post by slyme

wheres your code, its hard to fix something we cant see


you should have a query to the student table where the WHERE clause match the 1st table variable you previously queried, then use the variable to add the student in the select drop list option name.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.