Re: bug in pearweb/public_html/package-stats-graph.php
| From: | Martin Jansen | Date: | Sat, 14 Jun 2003 17:50:39 +0000 |
| Subject: | Re: bug in pearweb/public_html/package-stats-graph.php | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-17466@lists.php.net to get a copy of this message | ||
On Sat Jun 14, 2003 at 09:2321PM +0400, Alexey Borzov wrote:
> $sql = sprintf("SELECT UNIX_TIMESTAMP(d.dl_when) AS date, COUNT(*) AS
> downloads
> FROM packages p, downloads d
> WHERE d.package = p.id
> AND p.id = %s
> %s
> >>> GROUP BY MONTH(d.dl_when)
> ORDER BY YEAR(d.dl_when) DESC, MONTH(d.dl_when) DESC",
> $_GET['pid'],
> $release_clause = $rid > 0 ? 'AND d.release = ' . $rid :
> '');
>
> Thus months of different years are grouped together. The marked line should
> be
>
> GROUP BY YEAR(d.dl_when), MONTH(d.dl_when)
Patch applied.
--
- Martin Martin Jansen
http://martinjansen.com/