Hello
I have a mysql database with about 3,000 records. People can search the database and have between 1 and 3,000 records returned, depending on their search criteria. Search results are displayed with pagination, 10 at a time.
Now, I want to create a running total of how many times each record has been viewed, but only if the record is displayed on the actual page. So if someone did a search that returns 100 records I don't want all of those records to register a view if they only actually view the first 10 records.
Hope that makes sense, any help would be much appreciated.
Many thanks