Have you tried using it like this

*select count(*) from products;*


Chaitanya

"A man can get discouraged many times but he is not a failure until he stops
trying..."




On Mon, Feb 15, 2010 at 10:39 AM, Karl DeSaulniers <k...@designdrumm.com>wrote:

> 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