Multiple drop down lists via php MySQL

[sheryprince]

Hello Friends!.... here is the big idea. I am trying to make a form in which there will be 2 drop down lists which will be populating directly from MySQL DB ....

Actually i am developing a student management system as my first PHP project... here i want to have 2 drop down lists first is roll number and second is student name. i want that when some one select the roll number in the first drop down the student name against it is automatically populated in the next drop down.

 

 

Plz help me friends i am new to php and dont know soo much.! any help PLZZZZZZZZZZ

[voip03]

You need a AJAX

[sheryprince]

You need a AJAX

Thankyou for the reply!

 

Can you plz guide me a little more.............. Please!

[WebStyles]

you use javascript to grab the selected name in the first dropdown. you can trigger the javascript function with the element's onchange tag.

You can do a select box with onChange="functionName(this.value);" to send the name, then you use ajax to send that name to a php file that will build the second dropdown and send it back to your javascript, Once you grab the AJAX responseText, you use somthing like this to print the combo onto the page:

document.getElementById("divName").innerHTML = returnedComboBox;

[voip03]

For your reading

http://roshanbh.com.np/2007/12/change-dropdown-list-options-values-from-database-with-ajax-and-php.html

[sheryprince]

Solved:  Thank you Guyz... Thanks  alot ... finally i was able to figure it out.

 

 

Thakyou!

 

 

[voip03]

That Good. Please make it solved.