Monthly reporting

[Scott Haneda]

I just hacked out a script that will give me a month at a glance in MySql
3.x, I was thinking, there must be a way to do this in SQL.

Table
-------
Name (varchar 48)
Date (timestamp 14)

Currently, I select distinct on the name to get all unique names, then I
iterate on each name and issue a count() in SQL for each day of the month.

It is this ~30 days in script I bet I can get rid of, any suggestions how to
do this in MySql in one go and get a report of a "month at a glance"...

-- 
-------------------------------------------------------------
Scott Haneda                                Tel: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.