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