Check out GROUP BY -----Ursprüngliche Nachricht----- Von: Scott Haneda [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 6. Februar 2004 23:34 An: MySql Betreff: iterating through a month
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: 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]