On Tuesday 29 July 2008 00:57:22 Paul Jinks wrote: > Jason Norwood-Young wrote: > > 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. > > Hi Jason > > Hmm, food for thought. music-map is brilliant, though not what I'm > looking for graphically at the moment (was surprised to find Cesaria > Evora in close proximity to The Cardigans but I digress). > > What you describe is pretty much what I'm chasing, thanks and helps me > down the road, particularly with thinking about the database set up. > They 'only' problem is, my php/mysql skills are some way behind my > javascript/actionscript knowhow (I'm pretty much a noob here); what I > could use now is a how-to tutorial to give me some code to work off, > either online or in a book. If it ain't there, I can build from scratch > but it's going to mean a lot of calls for help! =) http://www.google.com/search?q=mysql+php+tutorials&ie=utf-8&oe=utf-8&aq=t&rls=org.debian:en-US:unofficial&client=iceweasel-a I like from scratch... =D I guss I can do that cuz I don't make a living out of it ;D > > Many thanks > > Paul -- --- Børge Holen http://www.arivene.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
