I've got a news script.
In the table for the news items I have a field called "link".
This field "link" contains the url that people can click when they want to read more.
Basically I am going to be serving quite a few news stories a day and want a way of tracking how many click thru's each story gets. I am not fussed about individual users, just the total quantity of clicks.
I want to use this information so that users can sort the news archives not just by id ASC and DESC but by popularity ASC or DESC(based on tracking the clickthru's).
I am presuming I will need to add a field to the table for news items for tracking the number of click thrus. I could call it "clicks" for instance.
I am at a loss as to how to do it easily.
I am also presuming it will be something to do with the way I process (or call to) the "link" field in the news items table?
Any help/idea/rants would be appreciated. I just don't know how to incriment the table based on the url. I know it's WHAT I've got to do, just not how to do it.
So who has the best method?
And lastly, thanks so much for your help here, I'm stretching the grey matter (hey, I'm an artist, not a REAL programmer (yet)
Rob