Looking for a Tag recipe
Posted: Mon May 07, 2007 10:42 pm
Hi Foumites,
I am thinking about implementing a Tag Keyword kinda thing for a website.
I am able to do simple things with MySql, getting stuff from tables, making categories assign items to categories etc, but this is beyond me.
A simple tag system that I would be able to make;
Just add tags to items, put the tags in a table and when a tag is clicked, search for the tags in the items.
But now the thing that I can't work out....
Suppose those items can belong to users, groups, subgroups etc (a variable subdivision).. and you want to show the tags only for the user, group or subgroup, how can you set up something like that?
Similar to Flickr.
The only thing I can come up with is to create a tag table for each user, groups or subgroup, and assemble the "master table of tags" from all those tables where appropriate, or something, but this gets very complicated, and uses lots of code and processor time.
Does anyone have an idea or can point me in the right direction?
Thanks
I am thinking about implementing a Tag Keyword kinda thing for a website.
I am able to do simple things with MySql, getting stuff from tables, making categories assign items to categories etc, but this is beyond me.
A simple tag system that I would be able to make;
Just add tags to items, put the tags in a table and when a tag is clicked, search for the tags in the items.
But now the thing that I can't work out....
Suppose those items can belong to users, groups, subgroups etc (a variable subdivision).. and you want to show the tags only for the user, group or subgroup, how can you set up something like that?
Similar to Flickr.
The only thing I can come up with is to create a tag table for each user, groups or subgroup, and assemble the "master table of tags" from all those tables where appropriate, or something, but this gets very complicated, and uses lots of code and processor time.
Does anyone have an idea or can point me in the right direction?
Thanks