Select SUM(colname) as newColName FROM SomeTable WHERE value='value';

Reference the 'newColName' as your variable.


-----Original Message-----
From: Cesar Aracena [mailto:[EMAIL PROTECTED]] 
Sent: January 17, 2003 2:17 PM
Subject: [PHP-DB] SUM(colname)

Hi all,

I'm trying to add all the values from the same column in MySQL with a
query like this:

SELECT SUM(colname) WHERE value = 'value'

But then I can't output it on the screen correctly. I've tried to put
all the results into an array and then make an array_sum($arrayname) and
it gives me exactly the double of what it should... any suggestions? By
the way, the column I'm trying to add is a DOUBLE 6,2.

Thanks in advance,

Cesar L. Aracena
(0299) 156-356688
Neuquén (8300) Capital

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to