Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

sum function results


Go to End


684 Views

Avatar
voodoochile

Community Member, 52 Posts

23 August 2012 at 2:43pm

Hi

i have the following function

 function ProductPrice() {
	
              $sqlQuery = new SQLQuery( 
               "Recipe.Weight * Product.CostPrice", //  Select 
     	"Recipe, Product", // From 
	"Product.ID = " . $this->ProductID
	 );
	 
    	$Price = $sqlQuery->execute()->value();

               return $Price;	
				
            }

this works a treat and does exactly what i want, my problem is i am trying to sum the results of this as their are several products per recipe i only want the sum of $Price for a particuar recipe.

i have tried the following but think it needs more as i want it to loop through based on the recipe ID and the array_sum may be wrong as well.

 

function TotalProductPrice() {
	
	
	$tpp = array($this->ProductPrice());
	foreach($tpp as $tpps);
	
	 return array_sum( $tpps);
	
}

any help is appreciated