Re: Getting total quantities
| From: | Chaitanya Yanamadala | Date: | Mon, 15 Feb 2010 05:34:30 +0000 |
| Subject: | Re: Getting total quantities | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46892@lists.php.net to get a copy of this message | ||
*Hai Chris
I already send him the right one. But my mail has been blocked by the php
lists. so i send a personal mail for him...
FYI....
SELECT SUM(ProductStock) FROM products;
*
if u want to give an other name for the row then use it as *
**
SELECT SUM(ProductStock) as stock 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 11:02 AM, Chris <dmagick@gmail.com> wrote:
> Karl DeSaulniers 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?
>>
>
> This one.
>
> The "AS" gives it an alias (or shortcut) to make it easier to find in
> mysql_fetch_array etc.
>
>
> --
> Postgresql & php tutorials
>
>
>