Building populated drop down menus (IE Car Make/Model/Year, etc)

I am building a form that I need each menu to be populated based on the previous selected menu.  I would liek this to be done without having to refresh the page at each selection.  

The prime example would be to ask for the make of a car (Honda, Toyota, Ford, etc). Then when the user selects Ford, another menu is populated with the Ford models (Escort, F100, Explorer, etc). Then they can choose the specifc type (EX, LT, EB, etc) and continue on down as far as necessary.

I would like this to be in drop down menus, pulling the info from a MySQL databse using PHP, and preferrably run in javascript on the client side.  Thanks fo the help.
LVL 1
mopar003Asked:
Who is Participating?
 
b0lsc0ttIT ManagerCommented:
If you want a general example of using AJAX with a PHP page then you can look at http://www.experts-exchange.com/Database/MySQL/Q_22715336.html#19580584.

bol
0
 
b0lsc0ttIT ManagerCommented:
You need something that uses AJAX.  This will allow you to use javascript, the xmlhttp object, server script and DOM to change the page's content without reloading the page.

One of the best explanations and simplest examples I have found on the net is at http://www.skeymedia.com/programming/classic-asp-and-ajax-tutorial/.  There is also a good explanation on what AJAX is at http://en.wikipedia.org/wiki/Ajax_%28programming%29.  The reference site W3Schools has a good section on AJAX at http://www.w3schools.com/ajax/default.asp.

The server script is PHP but that isn't the important part of the AJAX process.  If you would like to provide some of your code then I can help you with doing this in your page.  Let me know if you want a general example using PHP.

Let me know if you have a question or need more info.

bol
0
 
b0lsc0ttIT ManagerCommented:
I'm glad I could help.  Thanks for the grade, the points and the fun question.

bol
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.