Hi all,
I'm currently updating the categories for blogs plugin (by Certi) and the way it was originally designed, the category for each blog is added to the blog's options tables. So, if you want to find all the blogs for a category, you have to query the main blog table, loop through that, and query each blog's options table to find out if it's in that category.
Is there any reason NOT to create a second join table (blog_category) to track blog id and category id? Certainly, in any other project, that'd be the way I'd design it. But, I'm not familiar with all the best practices of WordpressMU. So, I wasn't sure if there was some reason he'd have set it up this way initially.
Thanks!