I want to start a site where I will have free guitar tuning tips, by using videos, I plan to make the site pay for itself and possibly more using other means. So the whole idea of video on the web is complex which iv'e been studyng. I have already put video on a site and have editing software. My question is this, If you go stupid videos.com they have a very organized and easy to use video site. Could someone check that site out and tell me the level of complexity as far as a data base goes. Thanks, also while at the site, click favorites mouse and cheese, really funny. Thanks

that's click most watched, mouse and cheese

Probably not very complex really.

You could probably do it with a single table (you may want to split it depending on how complex you want it to become)

Hold the video name, ID no, no. views, date (creation & last viewing), customer rating and the path to the video files.


For top rated,

select * from video order by view_date

Alphabetical

select * from vidoe oder by name

and so on...

thanks for the speedy reply. I'm completly new to this so I will research tables. did tables create the the box on the left that has the headings new videos, search, favorites? did the tables create the actual box you see. At the bottom it has play videos, how was the actual box that the site visitor see's created? with tables?

I've replied to your PM, but databases are not really a newbie topic (depite what Microsoft would have you believe with MS Access !), you need to think about the underlying data structures and how you want to use the data, if you design it wrong, it's a real pain to re-visit later.

To start somewhere, what is the box on the left called, where the video selections are in the scrool list when you visit stupidvideos.com, thanks