php mysql arrays and totals
| From: | Wendell Frohwein | Date: | Fri, 18 Jul 2003 10:18:32 +0000 |
| Subject: | php mysql arrays and totals | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29324@lists.php.net to get a copy of this message | ||
I have been searching all over the internet and yet I have not found the
answer to my problem.
I have a mysql database which stores dollar amounts. The table is called
items, the field is
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
only thing I can come up with is a long string of numbers. instead of
getting lets say 100,
I would get:
10101010101010101010
any help would be greatly appreciated, thanks