RE: [PHP] Column Totals
| From: | Ben Miller | Date: | Mon, 15 Nov 2004 18:17:14 +0000 |
| Subject: | RE: [PHP] Column Totals | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-202061@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: Robby Russell [mailto:robby@planetargon.com]
Sent: Monday, November 15, 2004 11:12 AM
To: benipmiller@comcast.net
Cc: php-general@lists.php.net
Subject: Re: [PHP] Column Totals
On Mon, 2004-11-15 at 11:01 -0700, Ben Miller wrote:
> SELECT SUM(Revenue) FROM Sales WHERE Date='$Date'
What happens when you do:
SELECT Revenue FROM Sales WHERE Date='$Date';
Make sure you're getting values back first..and then you can try to sum
them.
-Robby
--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 ---
****************************************/
I am getting values back in this case, if there are values for the given
date, that is. If I do:
while ($row = mysql_fetch_array($result)) {
extract($row);
echo
"<TR><TD>$Date<BR></TD><TD>$Revenue<BR></TD></TR>";
}
for example, it returns a long list of individual sales.
Ben