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@xxxxxxxxxxxxxxxxxxxxx] Sent: Monday, November 15, 2004 11:16 AM To: benipmiller@xxxxxxxxxxx; php-general@xxxxxxxxxxxxx Subject: RE: 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'] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
