COUNT function..

[janhouse00]

Hello, I am working on a log file that logs daily hits. My question is: could it be possible to get the total hits for a specified duration of time?

I've tried this and it doesn't seem to work:

SELECT COUNT(HITS)
FROM tbl
WHERE MONTH(date)=$month

Thanks

[stolzyboy]

SELECT COUNT(HITS) as hitcounter
FROM tbl
WHERE MONTH(date)=$month