-
From: Mike Gifford [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 11 January 2002 08:12
Subject: [PHP-DB] GROUP BY MONTH(DateBilled) misses an entry consistently
Hello
I've got the following SQL Query, which consistently pulls up only 3 out
of 4 months from
Hello
I've got the following SQL Query, which consistently pulls up only 3 out
of 4 months from the database:
$sql = SELECT COUNT(DateBilled) AS count, MONTH(DateBilled) AS
BilledMonth, YEAR(DateBilled) AS BilledYear FROM Invoices GROUP BY
MONTH(DateBilled) ORDER BY DateBilled ASC;
This
,
=dn
- Original Message -
From: Mike Gifford [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 11 January 2002 08:12
Subject: [PHP-DB] GROUP BY MONTH(DateBilled) misses an entry consistently
Hello
I've got the following SQL Query, which consistently pulls up only 3 out
of 4 months from
-
From: Mike Gifford [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 11 January 2002 08:12
Subject: [PHP-DB] GROUP BY MONTH(DateBilled) misses an entry consistently
Hello
I've got the following SQL Query, which consistently pulls up only 3 out
of 4 months from the database
On Saturday 12 January 2002 00:20, Mike Gifford wrote:
Hello,
Thanks for your quick reply.. I'm trying to improve the stats feature
for gcdb (a pretty decent little PHP/MySQL accounting package on SF.net)
On Fri, 2002-01-11 at 05:24, DL Neil wrote:
Have you posted all of the relevant
PROTECTED]
To: [EMAIL PROTECTED]
Sent: 11 January 2002 08:12
Subject: [PHP-DB] GROUP BY MONTH(DateBilled) misses an entry consistently
Hello
I've got the following SQL Query, which consistently pulls up only 3 out
of 4 months from the database:
$sql = SELECT COUNT