RE: [PHP] Column Totals
| From: | Ben Miller | Date: | Mon, 15 Nov 2004 18:21:45 +0000 |
| Subject: | RE: [PHP] Column Totals | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-202065@lists.php.net to get a copy of this message | ||
That did it perfectly. Why don't any of the stupid books tell you that you
need the AS statement?
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@niicommunications.com]
Sent: Monday, November 15, 2004 11:16 AM
To: benipmiller@comcast.net; php-general@lists.php.net
Subject: RE: [PHP] Column Totals
[snip]
The following query seems to return an empty string, which should only
give
me the total for the entire column anyway.
$query = "SELECT SUM(Revenue) FROM Sales WHERE Date='$Date'";
[/snip]
$query = "SELECT SUM(Revenue) AS Revenue FROM Sales WHERE Date='$Date'";
note the AS statement---------^
$foo = mysql_query($query, $connection);
$bar = mysql_fetch_array($foo);
echo $bar['Revenue']