I have a DB that records visits to my site. What I would like is a single SELECT statement that will show total visits in the past day, week, month, year. I know how to do it for a single category (ie SELECT * FROM Data WHERE Date < NOW() - interval 7 day) but not four at once. I would like to do it without 4 different select statements. And if COUNT () is the answer can I get an example. I can never get COUNT () to work right.
