James:
I tackled this problem a while back when writing a simple CMS for my company. I didn't like the idea of iterating a field in a database because there would be no way of auditing the data. You also couldn't segment results. In my situation, I wanted to ignore my own "clickthroughs" so I could test and such. One way to do this was to have a single row per click (like your second example) and store the clicker's IP address as well. This way I could get total clickthroughs and *unique* clickthroughs using SQL's simple "Group By" syntax. Anyway, hope this helps! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
