HELP!! PHP/JAVA dynamic lists..

[Anon]

I am in need of some help here.. What I am trying to do is...

Say I have a database with Name,Address,Phone.... Now on my web page I have PHP populate a dropdown box with all the names.. I need to be able to select a name from the dropdown list and have address,and phone populated automatically WITHOUT refreshing the page, Then these vaules need to be submitable back to a database, or at least there IDs... I know I need to use javascripts to do this.. Currently I am trying to have PHP generate a javascript multi dem array that will hold all the info for the names in the dropdown, but i can't get it to work and I am not sure how to make the java script select certain things from the array to go into certain text feilds.. Any help would be greatly appreciated...

[Anon]

Hi,

Firstly, careful of having a page with adress details "ready to appear" in your form. As the size of your address database grows, this page will become unmanageable in size.

That said, I reckon this will get you on track:

Get PHP to copy the array into a javascript array:

<? print("<SCRIPT LANGUAGE=JavaScript>");
print("var Adresses = new Array(\"$streetNo\", \"$streetName\" .... etc.

Then in your drop-down, include:

onchange="javascript😃oTheAddressThing();"

Where your JavaScript function DoTheAddressThing() updates the feild entries from the javascript array. (See any JavaScript help page for how to do change form entries instantaneously. I think it is something like form.mine.addressLine1.value='128 Jones St' ....but don't quote me).

I reckon you'd be better off refreshing the page and loading the correct address stuff from the db on each refresh (use "OPTION SELECTED" and some php to resume the page on the correct drop-down option).

....but I assume you have a good reason why you don't want the page to to reload, in which case, use the huge javascript solution above.

Hope this helps a bit.

Cheers,
Duncan.

[Anon]

thanx... yea I don't wan the page to refresh cause its a 138 feild form and I don't want to have to refresh 30 times for all the drop down select stuff but each drop down will be pretty small like there will never be more that 10-15 addresses at a time.. And its all on an intranet so the load time is not an issue.. thanx for your help..