Re: SQL sum function to store as single variable

i think this will work

$totalamt=$total[0]['CustomerPurchases'][''SUM(amount)'];

return $totalamt;

On Wed, Apr 25, 2012 at 1:03 PM, jasonix <jayhinanay@gmail.com> 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

--

Litto Chacko

Axtec Softwares

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