Re: SQL sum function to store as single variable

Am 22.04.2012 20:24, schrieb kdubya:
> [...]
> This can be written as a find():
> $total = $this->CustomerPurchases->find('first',
> array('conditions'=>array('customerbill_id'=>$billid),
> 'fields'=>array('sum(customerpurchases.amount) as total'));

I think something like

$total = $this->CustomerPurchases->field('SUM(amount)',
array('customerbill_id' => $billid));

should do the trick

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php