Do you mean that you executed the query from the Cake debug information directly on your mysql-server ?
If that is the case I have no idea where the difference in results is coming from ... On Mon, Oct 5, 2009 at 8:32 AM, vekija <[email protected]> wrote: > > Hi, > > I'm having a problem with sorting the recordset with order by and > group by statements. Would appreciate any help. > > There are 2 models, Team and Vote (Team has many Votes) and I want to > order teams based on the number of votes they got. > > Here's the find call: > $teams = $this->find('all', array('fields' => 'Vote.team_id', 'order' > => 'COUNT('Vote.team_id'), 'group' => 'Vote.team_id')); > > At the moment there' s only one team in the database with 3 votes. > However, the above query returns 2 (duplicate) records but when I > place the same query directly in the mysql it works as expected and I > get only one. > > Any ideas? > > thank you > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
