Re: [php]: monthly statistics
| From: | John Taylor-Johnston | Date: | Mon, 19 Sep 2005 03:25:32 +0000 |
| Subject: | Re: [php]: monthly statistics | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-222621@lists.php.net to get a copy of this message | ||
Tim Van Wassenhove wrote:
On 2005-09-18, John Taylor-Johnston <John.Taylor-Johnston@cegepsherbrooke.qc.ca> wrote:http://www.mysql.com/search/?q=YEARMONTH&charset=utf-8 http://ca3.php.net/manual-lookup.php?pattern=YEARMONTH JohnHi, Where could I find a monthly statistic plugin that can take myAll 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?StampDatefield and generate monthy graphs of my primary keyid? I'm sure I,m not the first to ask? ;-) CREATE TABLEcounter(idint(10) NOT NULL auto_increment,StampDatedate NOT NULL default '1999-12-31', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=26050 ;