I have a table where I store information about every single time a page has been loaded. So I have these rows: id, ip, date. Now I want to
You should be able to use
group by and
count to pull the most views by IP.
select ip, count(*) as count from logs group by ip order by count desc limit 5
Simple Demo: http://sqlfiddle.com/#!9/fa26a3/1