Reply to Re: [php]: monthly statistics

Your name:

Reply:


Posted by Tim Van Wassenhove on 09/19/05 03:44

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>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация