need some advice - counting website visitors

[adammc]

Hi Guys,

I am designing a very basic affiliate script...
I am having trouble getting my head around how to best store the clicks sent to the website through the affiliate script.

Banner on affiliate site, user clicks ---- >
sent to mysite (through affiliate link) -->
count hit, store click (+1) in stats table in DB for the relevant affiliate)

I plan on having a table for the affiliates name,adddress, user, pass & details.
And a 2nd table for for the affiliate stats.

Is it going to be much load on the server to store the clicks like so?

Stats Table Structure

ID (auto) ¦¦ Affiliate_ID ¦¦ Date/Time(of hit) ¦¦

This data would then be used for admin & affiliates to check there statistics.
Having the option to view stats by month and year.

Or is there a better way?

Any help would be greatly appreciated :)

[coopster]

Would you even need the auto ID on the Status table?

[jatar_k]

you could store the refere for the click if it available also, might be relevant for affs that use multiple sites. You could tell them which are converting better.

any help you can give them is better.

as coop said, you pobably don't need the auto id