drop-down box chainer

bump909

Is there a way of creating a drop-down box whereby selecting a value dynamically updates the list in an adjacent drop-down box?

Ideally, It would be great if the lists where pulled from an SQL database.
Any links to pre-written code would be greatly appreciated.

sarahk

My example doesn't use a drop down but fills text boxes. Just a bit more work to extend it.

http://sarahk.pcpropertymanager.com/muck/example.php

It's a framework that can be useful if you need to query the database to get the new values.

Otherwise, drop the iframe and just have the new values in an array on the page and rework it.

Sarah

bump909

The example works great and I could probably make good use of this but once I downloaded the zip file and ran the code, it fell at the first hurdle. Line 2 & 3 include files from elsewhere. I presume these are essential for it to work. Any chance of providing them to me?

Regards,
Kris

sarahk

Sorry, keep forgetting to add comments. What you see is actually the code I run and those two lines are for my hit counter. Comment them out, it'll work.

Sarah

bump909

Hi Sarah,

Thanks for the support. The page now loads correctly but no values are updated to the fields: noises and offspring. Forgive me if I'm being nieve but i'm not too hot on Javascript.

sarahk

can I see it?

bump909

Ahh,

I've uploaded it to my web server and it works fine: www.bumpstudios.co.uk/example.php
Doesn't work on my local testing server though. Must be a setting on my machine needs altering.

Many thanks.