Welcome to WebmasterWorld Guest from 22.214.171.124
joined:Nov 12, 2005
I would think the easiest way would be to query the entries with the most "votes" within a time period (say 24hrs), but there is definitely more to this than just that.
I guess it would depend on what you thought of as popular--Whether it be the number of votes, the rating from those votes, or how many people actually viewed that specific content, or a combination of the these and more. Once you figure that out, a simple query correctly executed should give you the results you want, that is, if the data is stored correctly too ;)