advance click counter mysql or flat file
- by jay
Hi,
First of all Thank You for looking.
whats the best method for make an advance click counter (eg. order by views [today] | [yesterday] [this week] [last week] [this month] [last month] [all time] ).
Is it better to use a flat file or mysql?.
This is the MYSQL Structure i came up with.
id (type: int(11))
link_id (type: int(11))
date (type: date)
counter (type: int(11))
please can you advice me on whats the most effective way of doing this.