Need some ideas on what would be the most efficient mehod of displaying, by month, a users data for a Ad Banner script I am writing.
Basicly what I want to do is be able to pull a log file (well actually a MySQL record) and display, by week/month/year each individuals tracking stats.
I am just basicly torn about what would be the most efficient.
Should I set an origin date when the record is created, then count the weeks from ther (lets say they joined on day 104 of the year, decide wether or not it's a leap year, then divide by 7 to find out how many weeks into the year they were and go from there?)
Just basicly finding myself at a point where being a perfectionist is really starting to kick my ass
And want a bit of general consensus on the matter.
Any input would be great.
Basicly what I want to do is be able to pull a log file (well actually a MySQL record) and display, by week/month/year each individuals tracking stats.
I am just basicly torn about what would be the most efficient.
Should I set an origin date when the record is created, then count the weeks from ther (lets say they joined on day 104 of the year, decide wether or not it's a leap year, then divide by 7 to find out how many weeks into the year they were and go from there?)
Just basicly finding myself at a point where being a perfectionist is really starting to kick my ass
And want a bit of general consensus on the matter.
Any input would be great.