2 May 31, 2005 18:11
1 doesn't work because you're not linking to a category.
It goes like this, barring any special settings, when you display a blog:
Select a blog (select * from evo_blogs where blog_ID = $blog)
Grab the categories associated with that blog (inner join evo_categories on cat_blog_ID = blog_ID)
Grab the posts associated with those categories (inner join evo_postcats on postcat_cat_ID = cat_id inner join evo_posts on post_ID = postcat_post_ID)
You're creating an entry in the evo_posts table, but NOT in the evo_postcats table, so there's no categories associated with the post.