Dynamic dropdown list

[367]

Hi,

i need a two dropdown lists where first (manufacturer) populates second (models) and when submit button is clicked it should lead to page of model, like this: index.php?p=view&m=shop&id=<certain_id>

all data is in one table and i can't change that: id, manufacturer, model, price, description

is there any example of something like this or someone knows how to do that?

thank you

[TFlan]

You have a couple options:

1) Ajax

You can use Ajax to onChange(this.value) of the manufacturer select, query your database with "WHERE `manufacturer`= 'value.passed.to.js.function'". Then populating your second dropdown with the return results.

2) Preload every list.

This is the option I would use. If I'm a user on your site and I have to wait X seconds every time I want to see a new list of models, I'm not happy.

I would use PHP to query your database for (unfortunately) your entire table (unless you know you don't need a few rows) for the `id`, `manufacturer`, and `model` columns (unless you need more).

Using those results, I would print them out into a javascript array and use the onChange() function of the manufacturer select to call for the respective array, which would populate the model select.

Originally Posted by 367

when submit button is clicked it should lead to page of model, like this: index.php?p=view&m=shop&id=<certain_id>

<form method="get" action="index.php?p=view&m=shop">
<select name="id">
<option value="mysql.id">mysql.model</option>

[Redcoder]

That can be easily done with Javascript. You need to use Client-Side Coding for that then use event triggers where selecting one option will trigger different values to be loaded on the other Drop-Down list.

Jquery can help you if you use the .change() trigger or .click()

http://api.jquery.com/change/

http://api.jquery.com/click/

Of course you need to know Jacascript to do that one.

If it is a particularly long Dropdown, you may combine it with Ajax and load it dynamically using a back-end PHP script that fetches Database data.