[eluser]Twisted1919[/eluser]
[quote author="techgnome" date="1287424138"]The answer, like all things, is "it depends". Can posts belong to one category and one category only? If so then add a category_id to the posts table. If they can belong to more than one, then, yes, you need a table in the middle that will hold the link between posts & categories.
To retrieve the data back, you would need to
select from the posts table, inner joined to the post categories table on the post id, inner joined to the categories table on the category id, where the category slug matches the parameter passed in.
-tg[/quote]
That's why i gave him the best advice he could get here.
He needs to understand and learn so that he can decide by himslef what's the best for each situation