actually, 'page stats' is only an example. i need it mainly for tracking external referral links.
i have coded a complete statcounter.com clone back in 2005 - but couldnt run it well because the server became super busy! now i am totally in love with cake, and want to build everything with it. On Jun 26, 5:55 pm, "dr. Hannibal Lecter" <[EMAIL PROTECTED]> wrote: > I know this probably won't answer your question, but here goes > anyway.. > > If possible, why not use Google Analytics? > > On Jun 26, 12:30 pm, Fahad <[EMAIL PROTECTED]> wrote: > > > hi, > > i am currently working on a site that requires reporting daily hits of > > its web pages. > > this is the SQL structure > > ============ > > table : hits > > id, page_id, hits, date (yyyy-mm-dd) > > ============ > > > there is a possibility that there will be days when the site receives > > no hits at all. therefore, no record will be stored for that 'date' in > > the hits table. and the table may look like this (assume i am > > recording stats only for the page with id #1): > > ======= > > table : hits (with records) > > id, page_id, hits, date > > 1, 1, 4, 2008-06-22 > > 2, 1, 7, 2008-06-23 > > 3, 1, 5, 2008-06-26 (notice the gap of 2 days) > > ======= > > > is there any way how i can get the missing days values (hits value > > will be set to 0) via model (probably using a behaviour)? > > > thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
