Would it be?

$q = "SUM(ProductStock) FROM products";

or

$q = "SELECT SUM(ProductStock) AS ProductStock FROM products";

if I want to return $ProductStock as the value?

Karl



On Feb 14, 2010, at 10:55 PM, Karl DeSaulniers wrote:

Hello List,
I have a situation where I want to figure out the total number of products in my database. I want to read all the fields $ProductStock and add them together to get the TOTAL number of products, not just the number of rows in my database.
Any pointers on the code to use for adding multiple rows field values?

EG:

Say I have three individual products and Product one has 10 and Product 2 has 20 and Product three has 5, and these values are set in the field $ProductStock, I want to get the result of 35 and not 3.

Any help is appreciated. TIA

Karl DeSaulniers
Design Drumm
http://designdrumm.com


Karl DeSaulniers
Design Drumm
http://designdrumm.com

Reply via email to