Problem form_mysql_linked_select_class

Hi,

your cascade dropdown menus are the best implementation I've seen.
However, if the first dropdown is not a static selection (as illustrated in the example) I have seriously problems to understand how to put it working.

In resume, two dropdown menus, both based on mySQL option retrievables.

Can you give me an example. The tutorial is poor.

Cheers
Joaquim

I think you always depart from a static number of options. If this is not what you want, you need to tell me how do you expect that the first select input gets the value of the group of options to display.

The first dropdown is Categories, the second one is Items and both are dynamic (new values can be inserted or removed anytime).

When I say dynamic I mean based on a mySQL query.

If not possible, the possible solution I can see is to use a first dropdown with the status (open or close). In fact I just want to show the Categories that are open at a given time.

Cheers
Joaquim

If the first select input is just one group of options, all you need to do is to query your database on the server side and pass an associative array to a regular select input.

Thanks Manuel. This exactly what I'm trying to do. Probably I'm misunderstanding something. An example from your side would be appreciated (if you have time).

Thanks in Advance
Joaquim

Just use as basis the example supplied with the class. The only thing you need to do is to query your database to build the $continents array instead of using fixed values as in this script.