Re: Is this possible in mysql?
| From: | Andrey Hristov | Date: | Fri, 08 Mar 2002 19:22:49 +0000 |
| Subject: | Re: Is this possible in mysql? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17582@lists.php.net to get a copy of this message | ||
list($sum)=mysql_fetch_assoc(mysql_query('SELECT SUM(salary') FROM employes;'));
Best regards,
Andrey Hristov
On Friday 08 March 2002 09:17 pm, you wrote:
> I need to add up the (integer) values of columns, and return the added up
> value as one column to php. Is this possible? Or is there something else
> to do it? (I'd rather not have to mysql_fetch_array() in a while loop and
> add it up there, it might be a lot of rows)