Re: query and group by

[Jeremie]

Hello,

I have got the same problem ...
Can anyone help us ?

        $request = "SELECT magasin, count(email) as total
                    FROM emails
                    GROUP BY magasin ORDER by total DESC;";

        $classementGeneral = $this->Email->Execute ($request );



And in my view (print_r) :

Array
(
    [0] => Array
        (
            [Email] => Array
                (
                    [magasin] => AMX
                )

            [#sql_4cc_0] => Array
                (
                    [total] => 271
                )
        )
)



Thanks
Jérémie


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---