Subcategories - a better way than mine

[eluser]TheFuzzy0ne[/eluser]
I was just thinking that perhaps you could have a column for indentation. Essentially, you'd grab your categories according to the indentation level, starting with 0, then 1, then 2 and so on. You'd need one query for each indentation level. I'm not entirely sure how it would work, or even if it would, but it might be something you'd want to consider. Basically, you need a method where is doesn't matter how many sub levels there are. It might even be an idea to store your categories in an array and serialize the data into a file.