PHP & MYSQL - DROP MENU SEQUENCE

Drayken

Can anyone direct me to the location of proper coding for what I call "Drop Menu Sequence". (The drop menu choices is prefilled/populated based on the previous menu selection.)

I have a sample ajax code, but can't seem to figure out how to get it to work. The tutorial works just fine, but when I edit the http: request wrapper, it does do anything.

I know the issue is how to utilize a dynamic drop menu and pull from the mysql database based on the previous selection.

Any suggestions or any abuse from the gurus who, I'm sure, this is simple for.

johanafm

First off, I wouldn't modify the wrapper code. It's purpose is to deal with the generics of a request. You should just use that code by passing along data to set up the specifics of any given request.

Also, if you have working code, then change or add something that breaks it, the error is likely to be in your changes/additions. It might also be that the data you send in the request can't be handled correctly by the server, in which case you have to go have a look server side.

So, start by checking what your browser's debugging tools tell you. My favorite is Firefox's error console along with the Firebug extension. If you get no error message there, check your php error log.

Roger_Ramjet

It is possible to just use Suckerfish Dropdowns instead of chained selects to acheive your objective. Create the nested menus with the select lists that would apply for each parent menu option. This removes the need for any additional page calls/ajax to populate a new select on the basis of prior selection. I have done this myself and would show you some code if I were at home now - don't have the code here unfortunately. You will need to use some js to populate a form field with the menu chioce clicked by the user, but that is simpler than the js and php ypu would need to do this with ajax.

Alternatively, there are lots of post here on Chained Selects, just use the search at the top.