Re: Categories like wordpress

On May 1, 2008, at 743AM, Richard Heyes wrote:

Is this how its done or am I barking up the wrong tree?

You have multiple options: 1. Fully normalised, where you have three tables - one for your "articles", one for your categories and a link table.

This is the route that I would suggest, it's the most flexible and fastest to query. Just to expound a little... images table: - image_id - image_filename category table - category_id - category_name image_category_mapping table: - image_id - category_id Then when you want to get all of the images for a category: SELECT image_id, image_filename FROM images JOIN image_category_mapping ON images.image_id = image_category_mapping.image_id WHERE category_id = 10; Getting all the categories an image is in: SELECT category_id FROM image_category_mapping WHERE image_id = 42; It seems like more work than the route you described, but it's way more flexible, and as Richard pointed out, it's fully normalized. Brady