Re: SQL sum function to store as single variable

Cake finds return arrays. Simply extract the value you want from the array.

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 25 Apr 2012, at 08:33:53, jasonix wrote:

On Apr 24, 2:48 am, 0x20h <k...@informatik.uni-marburg.de> wrote:

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

yes, but it still returns an array... what i want is to return a float
value..

--
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