subcategory solution

[eluser]Twisted1919[/eluser]
The correct database schema for categories would be a single table referencing itself . So you will have category_id and parent_id , and you can go how deep you want with this . But that's not the point of the thread , i think the O.P was just in doubt how the controller should look like , and a good starting point is my first post .
L.E: @Tominator , maybe you should take a look at database normalization, your structure is not as good as it must be in order to maintain a database in easy steps .