Posted by John Taylor-Johnston on 09/19/05 06:25
Tim Van Wassenhove wrote:
>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..
>
>
>
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
[Back to original message]
|