Values dynamically into dropdown

[wwfc_barmy_army]

Hello.

 

I have a database with two tables, car makes and car models.

 

The car makes is setup like this:

make_id | make_name

1            ford

 

etc etc

 

car models is setup like this:

model_id | make_id | model_name

1              1            mustang

 

etc etc

 

I've got a dropdown box with all the makes in, but when a make is chosen i need it to activate another text box and display the models for that make_id.

 

Any suggestions on how i might do this?

 

thanks.

[scvinodkumar]

Hi,

 

You can use ajax for this. use onchange to call the ajax function to get the models.

 

for example,

 

<select name="make" onchcange=get_models(this);">
.....
</select>

<input type="text" name="model" value="">

function get_model(id)
{
   call ajax function();
}

[wwfc_barmy_army]

hmm. Ok, i'll give it a go later. Thanks.