Re: [PHP-DB] Getting total quantities

Ok, sweet, then I am on the right track.
Now I did notice that I forgot the SELECT in the first query, does  
that matter?
Can I just start out with SUM?
Thanks for your response.

Karl

On Feb 14, 2010, at 11:32 PM, Chris 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
> http://www.designmagick.com/
>
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com