Re: php mysql arrays and totals
| From: | Dirk Kredler | Date: | Fri, 18 Jul 2003 10:26:11 +0000 |
| Subject: | Re: php mysql arrays and totals | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29326@lists.php.net to get a copy of this message | ||
Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein:
> called amount. I use mysql_query("SELECT amount FROM items"); to get the
> amounts into the script.
> I would then like all the values to be added up for a grand total. I have
> tried this and the
why dont you use :
SELECT SUM(amount) FROM items
?
best wishes,
Dirk