Blog category design

[nloding]

What I'm trying to do is create a category listing that can be applied to blogs, but it's a multi-user blog, so each category needs to be linked to the blog itself.  Here is a PNG image that illustrates what I'm talking about (unnecessary rows/tables blurred for privacy):

 

 

The table "blog_post2cats" seems incredibly messy, and it seems like there should be a better way to do this.  I based this design off Wordpress and the Lyceum modification to it.  I can't think of any better way to set this up.  Does anyone have any thought/suggestions?

[fenway]

So the categories are blog-specific too?

[nloding]

Right.  The idea is that each user can create custom categories for their own blog.  So I have the categories: movies, tv, books, video games; and you have the categories: mysql, php, web dev, salsa.  Each category has a description, and then is tied to a blog post.  But each post can have many categories assigned: if I write a blog about a book about movies, I'd tag both movies and books.  If you wrote one about designing a website for a salsa company, you might check all four.

[fenway]

Well, then there's not much else you can do... you need a table for blogs, posts and categories, and you need to be able to relate each pair.