[SOLVED] create a category table for every table, or create one category for all?

[ignace]

i have got 3 tables (faq, newsletter & content) should i create one category table for them all, or should i create an individual table for every one of 'em (faqCategory, newsletterCategory & contentCategory) this method however encourages redundant data as a category name may be useable in multipe tables (e.g. general is useable in faq, newsletter & content)?

 

Kind regards,

Ignace

[rhodesa]

I would use one table of categories

[ignace]

ok, but how do i distinguish them then? As a faq category name may be not useable or strange to use in newsletter or content

[rhodesa]

Well, when displaying the categories on the front end, only show categories with items in them. On the backend though, when adding content, allow the admin to choose from all the categories.

 

It is also good because it allows you to link content. So on a Content item with category ABC, you can show links to Newsletters with the same categories.

[ignace]

yeah, i guess that would be my better option

 

thanks rhodesa

 

this topic is solved, but i can't find the solved button (*EDIT* found it! )

[rhodesa]

Solved button is a bit flaky...