Tracking monthly data for indivdual users.

Balthazar

Golden Member
Apr 16, 2000
1,834
0
0
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.