Ive been thinking for the past hour on how to find the most popular ID in my mysql database. Is this only possible through visitor counting or is there another way to do this but accurately? Basically when a user visitor any ID page. for example .php?id=1 or .php?id=2, I just want to know which one was visited the most so that I can display the 5 popular ID's visited.
I already set up a php code where it displays 5 supposed 'popular' items in the website, but it's really showing the first 5 records instead.
A good example would be http://www.nytimes.com
Any input would be helpful