Hi Everyone,

I have two MySQL tables, for example:

products sub_products

id category sub_id subcategory cat_id
1 house 10 bird 2
2 animal 20 cat 2
                            30 dog 2
                            40 fence 1
                            50 gate 1
                            60 horse 2
and so on.

I would think to get the info from the two tables I would use a statement such as:
"SELECT id, category, sub_id, subcategory, cat_id FROM products,sub_products";

Once I have the data, I only want the user to select one category from a drop list field and display the matching sub-category drop list in another field, for example:

Category ......... house ........ animal

SubCategory ... gate ... dog
                        ... fence ... cat
                        ... roof ... bird
                        ... steps ... horse

Is it possible to do this with PHP using two MySQL tables within plain HTML?

I have seen a number of solutions requiring the category and sub-categories to be entered as options within the PHP code, but this is impractical as I could use up to 100 categorys and 1000 subcategories.

Thanks for any assistance.

hi there
Let me tell you what i understood first. You have two categories 1 and 2. Now user should get a drop down showing both the categories.
Once he selects the category, he will get another drop down showing sub-category. Yes, it can be done if that is your question.
Display the cat-id in the first drop down [use distinct(cat-id)] and select the option user selects, trap the value in Javascript or PHP code and pass the value in the another query [MySQL doesnot support subquery]. Retrieve the values for sub-cat in another drop-down.
Let me know if I am clear.
Regards

sinapra

Thank you sinapra,

You filled in the missing bit that I have been after. Works ok now.

Thanks again .... cjp_qld.