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! =)
Many thanks
Paul
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
