iterating through a month

[Scott Haneda]

In MySql is it possible to repeat through a month, for example I would like
to 

Select count(user) from table where date = x

However, I want x to be a range from the first of the month to the last day
in the month, I of course would need to pass in a month and year value to
limit it to that month and year.

Basically, I am trying to provide a month at a glance report of total posts
by various users to a table.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.