Simple request code

[zzz]

I have catalog of articles. For internal purposes I'd like to set a counter to count each time an article is opened. I think I've got the general idea, but not sure what’s the best way to implement it. Do I need add a separate column to the table containing articles? Any guidance would be highly appreciated.

[devinemke]

if all you want/need is a simple count, then yes, add an integer column to the article table that updates each time an article is pulled out. if you need a more comprehensive running log of each request (date/time, user_id of requester, etc...) then i suggest storing all of that in a separate table using a foreign key to the article table.