Creating client-side dynamic dependent list boxes

[Zergman]

This is killing me, having a real tough time getting this to work.

 

What I want is to have 3 dynamic list boxes structured as box1/box2/box3 that change depending on whats selected in box1.

 

I've tried this tutorial I found here, its using javascript but I am getting desperate.

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19117&sliceId=2

 

Using PHP/MySql

 

I've rebuilt the page 3 times now following this tutorial letter by letter and its not working.  Database/page is using the exact fields as this page suggests but no go.

 

The parent box loads but when I select an entry, nothing comes up in my second box.

 

Sorry if this should have been put in the javascript topics but I've even tried hunting down php/mysql tutorials to do the same.

 

Have pitty for a poor soul that has to have this app done in 6 days LOL.

[genericnumber1]

Here's some tips on doing what you're describing using prototype/jquery... http://forums.devnetwork.net/viewtopic.php?t=60287

 

prototype and jquery are javascript frameworks/apis to make your ajax life a hell of a lot easier.

See also:

http://www.prototypejs.org/

http://jquery.com/

[Zergman]

Here's some tips on doing what you're describing using prototype/jquery... http://forums.devnetwork.net/viewtopic.php?t=60287

 

prototype and jquery are javascript frameworks/apis to make your ajax life a hell of a lot easier.

See also:

http://www.prototypejs.org/

http://jquery.com/

 

Thanks for the information!  Read through it and im having a hard time understanding it.

 

Any other suggestions?

[Barand]

If you have a db table structure like this example, with numeric keys

 

[pre]

country          region          city

----------      ----------      ---------

id      --+    id        --+    id

country    |    region      |    city

          +--<  countryID  +--< regionID

[/pre]

 

then the baaSelect class in my sig may help.

 

Otherwise there's AJAX, also in my sig 

[Zergman]

One day I can only hope to be half as knowledgeable as you all but what you suggested Barand was again over my head.

 

Sorry all for appearing stupid but im getting really stressed out by this deadline and am getting desperate for anything that would work.

 

I threw the code from http://bytes.com/forum/thread561790.html onto a page and it seems to work but I would require a 3rd box.

 

Where I am right now, I actually won't require the list box information to be in a database.  Just checked the requested data I was sent and its pretty small so thinking something like what I found on that page would work.