Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: open
which may have multiple subcategories
which in turn may have additional subcategories
..and this could go on for a few more levels (as a result of user input)
without creating a table for each subcategory since I don't know how far deep it would go?
In this table , u can store as many subcat you want.
iparent_id will have its parent cat_id value.
Would you happen to know the typical way to query a table like this? how do i get all the subcats in a query in the manner as:
category subcat1 subcat2
category subcat12 subcat2
category subcat12 subcat21