Hello I'm designing a news system for my website using php/mysql and I want to know which news are read the most.
I created a field in the DB called "hits". Every time the news is read I want that field from that record being viewed get increased by one. I already have the query for displaying the news on the page working fine, but I need the other query for update the hits count on the DB every time the record is viewed.
Any help would be appreciated.