You wouldn't be able to do that if you just have a counter which counts the totals. There are several ways to do it. You can log each visit in a table, then query based on time, grouped by table and ordered by count... You could also create a 'daily summary' table that logs page visits to it, and have a cron job that takes the days totals and adds it to the master 'totals table' and then clears the daily totals.
On Thursday, July 19, 2012 8:10:32 AM UTC-7, Andrew Evans wrote: > > Hello > > How can I query the database so it pulls the most viewed pages for the > current day. I have a counter that calculates views on each page in total, > I am just not sure how to implement it based on a time frame :-) > > *cheers and ty > > > --
