Related Triple drop downs in php with auto suggestion on the first drop down.

[SARAVANATAEE]

Hi all,
I have a query. I am working on a product system. I have list of products like a,b, c. And each will have its own package like small box, big box, etc. Each packages indeed will have quantity count. For eg. small box =120 and big box =300 etc.

So, the idea is i want to have a select box with autosuggestion on product. once selected product, i want to load the package for that particular product in my 2nd combo, then once selected package, it should load quantities for that package in 3rd combo. This is what my req.

Table structure is.
Product:
product_id product_name

1 A
2 B
3 C

Package table:
package_id Package_name Product_id quantity
1 small box 1 140
2 Big box 1 500
3 Small box 2 250

Can anyone help me on this.

[astonecipher]

What kind of help are you requesting? You load the products in a select. That changing sends an Ajax call to fill the next select, and so on.

[SARAVANATAEE]

Yes. I load the products into first select. Which i want as auto suggestion. Because i might have 500 products. selecting them individually is not possible. I either want select with auto suggestion or textbox with auto suggestion. But the product id should be passed to next select once i select the product.

Based on that product id, i want to load my packages and so quantity.