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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
aliwright
Forum Newbie
Posts: 1
Joined: Fri Jun 14, 2002 5:14 am

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

Post 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]
Pekka
Forum Newbie
Posts: 5
Joined: Sun Jun 16, 2002 11:48 am

Post 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/
Post Reply