count click system

[nuttynibbles]

hi, i need to do a count click system where it traces the number of click from a banner.

wat i did was "update table set click=click+1 where id=$id"; whenever a banner is click

but i need to trace down the number of click each month, therefore i realized i could not use the method mentioned above.

Any Suggestions ??😕

[jkurrle]

You could send a timestamp when clicked. Parse out the month and year and increment the appropriate month as needed.

Just a thought...

[nuttynibbles]

tks.. hmm i actually tho of tt method..i give it a shot first.. tks=)