PHP - Javascript - MySql

[Dillenger]

Hi,

I have a dilema, I have some info stored in a MySQL database with this info:

name
address
city
postalcode
phonenumber

I want to take this information, and have the 'name' field be in a drop down list. When you click on the name you want, the other data, being address, city, postalcode, phonenumber... will automatically fill in seperate textfields in a form, without a refresh...

I was told, that I need to take the data from the database using PHP and then convert the data into a Javascript array... I'm just completely unsure of how to do this. I can get the data with PHP, but I just don't know how to make the javascript arrays, and then how to display the info...

I want it to basically do what this form here is doing:

http://www.37signals.com/better/fedex/after.html

Any help on this subject would be very appreciated, thank you.

[nemonoman]

Start here

http://www.felgall.com/jstip22.htm

You'll want to create SQL/PHP statements that create and populate the javascript arrays. This is tedious but not difficult.

[Percadan]

Good solution!
That kind of helped me out as well, thanks.

[Jinks]

you can try to embed your php into your javascript. ( you can make the javascript value a php variable ) dunno if that will help though 🙂