-----Original Message-----
From: Robby Russell [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 11:12 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 | [EMAIL PROTECTED]
* 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
