Tim Van Wassenhove wrote:
On 2005-09-18, John Taylor-Johnston <John.Taylor-Johnston@xxxxxxxxxxxxxxxxxxxxx> 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..
How will I draw a graph <img src="reddot.gif" width=2
height=$mydate->number_of_hits_per_day>? Anything in the manual to look at?
http://www.mysql.com/search/?q=YEARMONTH&charset=utf-8
http://ca3.php.net/manual-lookup.php?pattern=YEARMONTH
John
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
