javascript for select options, to fetch options from table

jya

Here is my problem.

mysql table A:

customer -- Address
ABC -- addr1
ABC -- addr2
ABC -- addr3
XYZ -- addr4
XYZ -- addr5

I would like to have 2 html select statement,

1st one, choose the customer ( dropdown for ABC or XYZ ), once the customer has been choosen, the second select will automatic come up the address for selected customer only.

Can someone help ? thanks.

vaaaska

"javascript for select options, to fetch options from table"

Ask this in a javascript forum perhaps?

solodesignz

If you dont want to use AJAX...

Use php to genereate the second select statement.
Surround it by a div with an id:

<div id="hidden" style="display:none;"></div>

then on the first select add

<select onchange="if(this.value<0){document.getElementById('hidden').style.display="block";}">

the "if(this.value>0)" should be used if the select boxes values are an integer... and the fisrst one is something like this... "<option value=0>Select one...</option>"

Of course you should put the style in an external stylesheet file, as well as turn that javascript line into a function and put it into an external js file