Hello,

on 07/29/2006 03:30 PM Skip Evans said the following:
>  Since I get so much great info and help from the lists I'm on, every now
>  and then I like to try and give something back.
>  
>  I just finished some code that is pretty useful for populating one drop
>  down based on the selection of a previous one, so I thought I'd pass it
>  along in case anyone found it useful. I'm sure many of you already have
>  a way to do this in your toolbox, but thought some may not.
>  
>  I've seen many examples of doing this Googling around, but found them
>  overly complex, and I think I've come up with a quite simple and
>  affective way to do it with not too much code.
>  
>  Basically, I had a need to populate a dropdown containing areas within
>  the boroughs of New York City based on which borough was selected. So
>  say they select Manhattan in the first dropdown, the second dropdown
>  then becomes populated with the areas within Manhatan.
>  
>  The code  builds the possible arrays for the second dropdown from the
>  database when the page loads, then plugs them directly into the JS,
>  making the whole arrangement dynamic. Change the DB and the dropdown
>  adjusts accordingly.

Most of the solutions I have seen only allow to link 2 or at most 3
select inputs. Another common limitation is that they only work with
MySQL database queries.

Look here if you are searching for a solution that interconnects an
unlimited number of inputs and can work with many other database types
besides MySQL (say PostgreSQL, SQLite, Oracle, Microsoft SQL server or
Microsoft Access, etc..):

http://www.phpclasses.org/formsgeneration

Here you may see a example form in action with 3 linked selects:

http://www.phpclasses.org/browse/file/9879.html


-- 

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php