Re: [php]: monthly statistics
| From: | Tim Van Wassenhove | Date: | Mon, 19 Sep 2005 00:44:08 +0000 |
| Subject: | Re: [php]: monthly statistics | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-222614@lists.php.net to get a copy of this message | ||
On 2005-09-18, John Taylor-Johnston <John.Taylor-Johnston@cegepsherbrooke.qc.ca> wrote:
> Hi,
> Where could I find a monthly statistic plugin that can take my
>
StampDate field and generate monthy graphs of my primary key
> id?
> I'm sure I,m not the first to ask? ;-)
>
> CREATE TABLE counter (
> id int(10) NOT NULL auto_increment,
> StampDate date NOT NULL default '1999-12-31',
> PRIMARY KEY (id)
> ) TYPE=MyISAM AUTO_INCREMENT=26050 ;
>
All you need to do is SELECT .. GROUP BY YEARMONTH(StampDate) and you're
ready to go..
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>