Hi, thanks for the suggestions. Peter, I definitely think your second
solution, the one you said you are probably going to upgrade to, is very
clean: adding another table between categories and subcategories that
defines relationships between the two. it seems like it will be much easier
to code
I've done something similar by building a
multidimensional array of categories and subcats in
one query and then Loop thru this with a for each to
build the category structure.
Categories table looks like this
CatID | ParentID | CategoryName
Array is
$category_menu[$ParentID][$CatID]
I'm sure
I've been working on something like this since about September/October.
It's not too hard, but it did take more coding than I thought it would.
Now, there's a couple of ways you could do this. I chose the cheap (in
terms of the number of DB tables) way out.
The way I have it set up is this.