WHERE an GROUP BY - why is it not working together?

Hi
I have a problem - I use mysql db to store some stats data and I'm trying to
retrieve information on how many visitors came to my site in each day of
particular month

i have the following columns
+-----------------------+---------------+------+-----+---------+------------
----+
| Field | Type | Null | Key |
Default | Extra |
+-----------------------+---------------+------+-----+---------+------------
----+
| id | int(10) | | PRI
| NULL | auto_increment |
| timeofentrance | timestamp(14) | YES | | NULL |
|
+-----------------------+---------------+------+-----+---------+------------
----+

if i run:

select count(*) as sum
from stats
WHERE EXTRACT(MONTH from timeofentrance)='03' ;

the result is ok - I get the sum of all entrances in march
but then I want to group it by days so I use:

select count(*) as sum
from stats
WHERE EXTRACT(MONTH from timeofentrance)='03'
GROUP BY EXTRACT(DAY from timeofentrance);

and... it does nothing - i get the same result - not divided into days
if i run the same query without the WHERE clause, I get the results I want
but not limited to the month I'm retrieving data for...

any suggestions?
i use mysql 3.23.54

--
TIA
Patol

"Patrol" <patryk.bezspamuprosze@alfatel.zadnegospamu.pl> wrote in message
news:d04ofd$eh4$1@opal.icpnet.pl...
> Hi
> I have a problem - I use mysql db to store some stats data and I'm trying
to
> retrieve information on how many visitors came to my site in each day of
> particular month
>
> i have the following columns
>
+-----------------------+---------------+------+-----+---------+------------
> ----+
> | Field | Type | Null | Key |
> Default | Extra |
>
+-----------------------+---------------+------+-----+---------+------------
> ----+
> | id | int(10) | |
PRI
> | NULL | auto_increment |
> | timeofentrance | timestamp(14) | YES | | NULL |
> |
>
+-----------------------+---------------+------+-----+---------+------------
> ----+
>
> if i run:
>
> select count(*) as sum
> from stats
> WHERE EXTRACT(MONTH from timeofentrance)='03' ;
>
> the result is ok - I get the sum of all entrances in march
> but then I want to group it by days so I use:
>
> select count(*) as sum
> from stats
> WHERE EXTRACT(MONTH from timeofentrance)='03'
> GROUP BY EXTRACT(DAY from timeofentrance);
>
> and... it does nothing - i get the same result - not divided into days
> if i run the same query without the WHERE clause, I get the results I want
> but not limited to the month I'm retrieving data for...
>
> any suggestions?
> i use mysql 3.23.54
>
> --
> TIA
> Patol

Just put EXTRACT(DAY from timeofentrance) in to the select part!

> Just put EXTRACT(DAY from timeofentrance) in to the select part!

well, I gave it a try but it didn't help... any other ideas?
I guess I'll just have to loop the query 31 times...
anyway, thanks

Patrol