Page 1 of 1

Help me! PHP form with more than one dynamic list/menu

Posted: Fri Jun 14, 2002 5:14 am
by aliwright
Hi,

I am wanting to create a form which has three dynamic dropdown lists. All the information will be stored in tables in MySQL.
The first one is a product list. When you select a product, the second list dynamically populates itself with the relevant version numbers for that particular product. Then the third list contains the relevant platform versions, etc.

How do I create this? I can do the first list, but then get stuck. Can someone help me?

Cheers!

Ali. :wink: [/b]

Posted: Sun Jun 16, 2002 12:57 pm
by Pekka
http://photography-on-the.net/php/3_choice_select.php

There is source code and db dump link in the bottom of that page. The database is very normalized.

I did and debugged this in couple of hours (I know, I'm slow), and this needs _plenty_ of more code like clearing choices from "product" and "version" when "platform" is changed, and checking valid "platform" id etc... this is just a core which gives you id's for additional queries.

If you improve this please share the code!

Pekka
http://photography-on-the.net/ee/