How to Change Database in listbox

[Anon]

Now I create List box (Select list) by get data from my sql ...and when I want to change data in
list box ...I want to change in first list box and after change first list box ..then second list box will change together

example :
I select code product and when select this one
data in second listbox will change..
Can help me ...tell me how to coding or send
any code to me
Thank you very much for your answer...:-)

[Anon]

You can't do this just in PHP, which runs only on the
server. In order to get interaction between various
listboxes on the client browser, you need to use
Javascript (which of course you PHP script can
write.)

[Anon]

Oops, and the reason I'm not telling you how to do the
Javascript is that I'm not that experienced with it,
so I'll leave that advice to someone else here...

[Anon]

Thats what the wise and great rad said about doing it in js:

cya Rob

"you can do this with JS. define a javascript array, indexed by the values of the first select. each element of this array is then another array which contains the options for the second select corresponding for the entry in the first select. (did that make sense?) then when you make a selection in the first select, write the appropriate elements to the options array of the second select.

clear as mud ;-)

and, of course, you can get php to build all these arrays for you from a database 🙂"

[Anon]

... and here is an example...

http://www.devshed.com/ClipScripts/results/420/

cya Rob

[Anon]

thank you very much...:-)