From: Freddie Sorensen
Date: February 7 2004 7:29am
Subject: AW: iterating through a month
List-Archive: http://lists.mysql.com/mysql/159185
Message-Id: <8vbh3iqqk0m3j2y.070220040830@parawebic.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Check out GROUP BY=20

-----Urspr=FCngliche Nachricht-----
Von: Scott Haneda [mailto:lists@stripped]=20
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=20

Select count(user) from table where date =3D 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
scott@stripped                            Novato, CA U.S.A.


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Dfreddie@stripped