nloding Posted March 8, 2007 Share Posted March 8, 2007 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 8, 2007 Share Posted March 8, 2007 So the categories are blog-specific too? Quote Link to comment Share on other sites More sharing options...
nloding Posted March 8, 2007 Author Share Posted March 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 8, 2007 Share Posted March 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.