On Mon, 2008-07-28 at 14:48 +0100, Paul Jinks wrote: > I think my first post was ambiguous. What we're thinking of is to build a > site on which people can view videos with the option to add metadata to a > video after viewing it. > > We think that the content we have will be of wide interest to a lot of > people and the best way to index it is for users to 'tag' it themselves, > since it's hard for us to anticipate the uses that people may have for the > content. How do you plan to have users enter the info? Through the Flash player, through some kinda Ajax form, through a form in a frame or just a static form? Also, would the tags be predefined by you (eg. genres like the ID3 tag genres) or would people be able to add their own tags? The way I'd do it would be to let the users enter the info through an Ajax form below the video, with suggestions popping up as they type. Then save it in a separate table (I assume all your vids are in their own table) with a link table between the vids table and the tags table (M2M relationship). This means that if the tag is already in there and linked to one vid, you don't replicate it for a second vid. It's also very easy to do lookups of similar items. I'd also add a weighting to the tags in the links table, maybe with the more people that add a specific tag, the more weight that tag gets. Also check out http://www.music-map.com/ as an example of showing similar music - you might even be able to plug into this data. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
