Whats the best way to store hits/views in db



in php/mysql.
i want to count a view each time somebody views a video on my site. now whats the best way for me to count each view? i want to be able to have “most popular in the last 24 hours”, etc. so i must be able to know when each view happened, right?
and once i have these views, which would be the easiest way for me to find out the top 10 most popular in a certain time period?