dependent listbox

[wanaka]

Is there any example of how to create a dependent list box using php with javascript.

I have done the following using codecharge but it only work when you insert a new record. If you tried to edit a record, those dependent listbox still in the same value as before.

Basically I have three table manufactuer->equipment_series->model I need to create dependent listbox when a new device was added.

I have attached the necessary php and html template.

[BuzzLY]

Not sure what you are asking for... how to relate the three tables? You only included a gif, and it's almost impossible to read.

As for the tables, you need three:

manufacturer table:

• ID

• NAME

equip_series table:

• ID

• MFR_ID

• EQUIP_SERIES_NAME

model table:

• ID

• EQUIP_SERIES_ID

• MAKE

• MODEL_NUMBER

• SIZE

• COLOR

For example, when adding a new model, you simply insert the appropriate EQUIP_SERIES_ID and your next query should include the new model.

Is that what you are looking for?

[wanaka]

Hi,

I have included a larger version of image for your reference.

Actually I want to have s form to let user input and edit device. Due to large number of model, I want to setup three listbox which will let user first choose the manufacture -> equipment series -> model.

[BuzzLY]

Ok, so I deduce that what you are asking is that the equipment series and model listboxes change their values dynamically, right?

The problem is that this all has to happen in the client, and PHP is a server-based scripting language. In order to be able to do this, you would have to store every equipment series and EVERY model in some sort of array that Javascript would have access to. That can get very tricky, and you theoretically could have thousands and thousands of models, right? So this isn't practical.

You could give the appearance of a single page by using IFrames, but then you run into compatibility issues with some browsers.

I would suggest you have a series of forms, perhaps accomplished with a popup window, that first asks for Manufacturer, then Equipment Series, then the Model, and when clicking the "FINISH" button, the values are returned to the original form which the user can then continue to fill out.