how we fetch the data calendar wise data. like november month day wise

Question

I have a table mdr with field iduser, msg_count,msg_received. I want to count the msg_count  in the month of november on daywise data.

table mdr:--

iduer   msg_count    msg_receved

1             2                2011-11-06

2             4                2011-11-08

o/p like

iduser     day1      day2           day3     day4

1               2            0                0            0

 

solve this type of query in my sql