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: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
