On Tue, July 29, 2008 9:22 am, Jason Norwood-Young wrote: > > On Mon, 2008-07-28 at 23:57 +0100, 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! =) >> >> Many thanks >> >> Paul > > In that case, I suggest the following solution: > 1. Download the unternet into your puter > 2. Open the file called mysql.com > 3. Read and learn > 4. Open the file called php.net > 5. Read and learn > 6. Rinse and repeat > LOL > In all seriousness, this is a nice, simple project to learn on. You want > to look at different types of relationships in Sql (one-to-one, > one-to-many and many-to-many) and learn a bit about basic DB > architecture; make some tables and play with getting data in and out > (get PHPMyAdmin to help you out); maybe use a nice simple framework like > CodeIgniter to get you kick-started on the PHP. > Right, from scratch it is then (installs xampp, starts up PSPad, and cancels all meetings)... =) Cheers Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
