I'm working on adding profile view counters for the following: http://www.f1autoimports.com/inventory
I'm having a bit of difficulty figuring out what kind of algorithm to use so that only one counter hit per profile is registered with a user session. I think it makes sense for a users hit to increment the counter on multiple profiles, but only one per session.
Anyway, I'm looking for an elegant solution/algorithm/ideas. I already have a counter field in my table ready to go which defaults to zero for each new registered profile. I'd like to also leave the mathematics to MySQL, versus PHP.
Thank you kindly for your help.