21493 Posts in 5784 Topics by 2622 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 168 Views |
-
sum function results
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
| 168 Views | ||
|
Page:
1
|
Go to Top |
