Getting total quantities
in [Databases]
|
From: Chaitanya Yanamadala on 15 Feb 2010 00:34 *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(a)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 > > >
From: Karl DeSaulniers on 15 Feb 2010 00:36 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
From: Chris on 15 Feb 2010 00:43
Karl DeSaulniers wrote: > 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? No - that's invalid sql. -- Postgresql & php tutorials http://www.designmagick.com/ |