CMS for video, maybe?

I'm not sure if this is the right place to post this question, but her goes...

First, I just want to say that I have a pretty firm grasp on xhtml, and I'm OK with css (still a bit to learn), but I am a complete beginner for javascript, PHP and MySQL. I have done some "hello world" stuff, and played around with some very simple stuff like alert boxes and document.write.
With PHP, I have done some simple programming by using tutorials. I've done basic login/logout/register stuff and a few other simple things. I need to get some things done on a website I'm building, and I want to do it myself.
So here's my question...

I was wondering if anyone knows of a good way to accomplish this:

I am building a site for guitar lessons. I want to upload videos (just me, not the visitors) and have them saved by categories or groups in a database. I would like the user to be able to click a link to a category and have the list of videos appear. The list should show a thumbnail image next to a title and short description of each video.

I also have a separate task I'm looking into:
I want a carousel on my home page that will display featured videos from the database. I kind of like the way yahoo has it done on their home page. It shows a small horizontal scrolling box along the bottom, and whichever video you have highlighted in the scroller shows up in the main window.

I'm happy to do tutorials, if anyone knows of any good ones for this type of stuff. I'm also willing to use pre-made templates and look at the code and try to figure out what's going on. Basically, I'll do what it takes, but the search has become complicated for me because I don't understand much of what I am reading when I find stuff.

Please help!

Well to be able to store the videos in the database, you will only want to store a link to the video, so it's URL. But I don't see why you wouldn't just upload your videos to youtube, and then store the link to the youtube video in the database (exactly the same as you storing them, except you don't use your storage space ).

Check this link for the carousal thing you want: http://fredhq.com/projects/roundabout

When you query the database, you pull the information and put it inside the src tag of the video file. Fairly easy .

Denno

You did not say what type of site you were using so I think I would go with Wordpress. It can handle all different formats of media. It uses php, mysql, and html.

YOu can also get plugins to handle just about anythng you want to do.

Here you go mate

First of all I am passionate about guitar also and the idea you have is great.I think this is a good way to learn and practice with a teacher online.

So when i read your post i was exicted to help a fellow guitar player and this is what I have thaught it might be useful:

http://www.flashxml.net/youtube-vimeo-player.html

The best features about this player are that you can upload the video/mp3(FLV, MOV etc.) localy or you can use other video services like Vimeo or Youtube. The player has smooth transitions and the playlist is fully customizable.

Best of luck,

hello, you can also try to use a pre-made-templates i always do the same in order to get a inspiration and ideas, plus getting a useful codes to play with and trying to achieve my goals, concernig the idea it's really cool, you can use a CMS (content management system) scripts such joomla, wordpress,vidiscript.. but you will need to edit a lot of stuffs.. you can do a glance at http://www.template4all.com maybe that will give you some ideas...