searching
Posted: Thu Jul 29, 2004 2:56 am
K I'm building a template system for my comany and I want a customer to be able to click on a catagory and have all the templates in that catagory be displayed.
The problem is a template can be in several catagories.
What do you guys think I should to with my DB.
Should I do
catagories table
catagory | templateids
gaming | 2, 25, 42, 13
or should i do
templates table
templateid | catagories
2 | gaming, flash intro
Also anyone have any idea how I would compare the results?
I have a fair grip on this but just wondering if anyone could throw me some useful advice
templateid | catagories
The problem is a template can be in several catagories.
What do you guys think I should to with my DB.
Should I do
catagories table
catagory | templateids
gaming | 2, 25, 42, 13
or should i do
templates table
templateid | catagories
2 | gaming, flash intro
Also anyone have any idea how I would compare the results?
I have a fair grip on this but just wondering if anyone could throw me some useful advice
templateid | catagories