[eluser]Xeoncross[/eluser]
[quote author="yelirekim" date="1218492100"]In order to do this with the system you're talking about, you need to create a new record for every single tag on every single blog posting, duplicating the tag names in many cases.[/quote]
Oh! Thats right!
However, they method posted still isn't right either (unless only one table uses tags).
How about this:
Tables:
Code:
tags : id, name
tags_for : tag_id, item_id, type,
posts : id, title, content
links : id, title, url
files : id, name, url
Code:
$query = '
select * from (posts left join tags_for on posts.id = tags_for.item_id) left join tags on tags_for.tag_id = tags.id';