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 -~----------~----~----~----~------~----~------~--~---
