I have news items stored in a database and a column to record the number of views...
on the main page of my site, i would like to view the top 15 clicked on news stories over the last 4 days, and then sort those by date.
can mysql do this directly? or will i have to store the values in an array, and then sort by date?
on the main page of my site, i would like to view the top 15 clicked on news stories over the last 4 days, and then sort those by date.
can mysql do this directly? or will i have to store the values in an array, and then sort by date?