Re: Getting total quantities

From: Date: Mon, 15 Feb 2010 05:32:02 +0000
Subject: Re: Getting total quantities
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-46890@lists.php.net to get a copy of this message
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/

« previous php.db (#46890) next »