Little Advice

[Anon]

Hi,
I'm doing a programming help site and I've come accross the problem of storing the sub categories for each language(15). The way I have it set up is Type > Language > Sub categories
I need to select the appropriate sub cats for the language selected. Would be easy except each language has different sub categories. I appreciate any help that you may have for me.

Thanks,
Jeremy
www.CodeHeadz.net

[Anon]

You will need to set up your database tables appropriately. An example schema might look like this:

help_type

help_type_id // the id column
description // the name/desc
... //other fields

language

lang_id
help_type_id // link it to the type
description
...

category

cat_id
lang_id // this key links this cat to a lang
description
...

You could also do this all in one table, using a node like approach and then joining the table against itself. For simplicities sake, I went with this easier layout.

G'luck,

Jack