Count hits to record on DB

[pulsorocker]

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.

[Paul S]

After calling the record, use the query,

sql = "UPDATE newstable SET hits=hits+1";

[pulsorocker]

Thanks.. I'll try it.
And what type should that field be? Would "INT" be ok?

[Paul S]

Yip