Hi, this query here doesn't work

http://bin.cakephp.org/saved/47129

So i tried using sql query browser to check whether my query statement
is correct.

select distinct month(created) as created,
sum(cost) as total_cost
from finances
group by created;

And the result is the same, here's the array

http://bin.cakephp.org/view/614424760

The months are not unique and the costs are not summed up. Please
help, my big thanks to those who would spend time reading this.

Regards,
wayne

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to