[eluser]lenwood[/eluser]
This is great, VERY helpful. Thanks to all of you for informative responses!
[quote author="n0xie" date="1271702216"]We use different relations table for that named blog_tags.[/quote]
You lost me here, I don't know what a relations table is.
[quote author="dmorin" date="1271708295"]n0xie's response is pretty good, but limits you to one category per post. Most blog engines allow multiple categories per post so if you're looking for that, your posts-to-categories relationship will be many-to-many instead of one-to-many so you'll need an intermediary joining table like he created for tags... Do you understand table relationships and how to do joins or do you need further explanation on that?[/quote]
No, not at all. I've never set up a database for an application before. The extent of my experience is creating a database for WordPress. I will want the ability to have multiple categories per post.
I need to do some more reading...
