Re: Help doing this in CakePHP

Hi,

if I understood you right, this could be what you need:

$result = $this->YourModel->find('all', array('group' => array
(domain_'id', 'search_engine_id'),
'order'
=> 'MAX(created)'));

With pagination it should look like this:

$this->paginate['YourModel'] = array('group' => array(domain_'id',
'search_engine_id'),
'order' => 'MAX
(created)');
$this->paginate('YourModel');

In both cases you can get related data with the 'contain' option in
the array.

Hope this helps,

Michael

On 3 Nov., 00:29, Chad Casselman <ccassel...@gmail.com> wrote:
> I have a table that looks like:
>
> id      created         modified        domain_id       pages   search_engine_id
> 92      2009-11-02 14:32:11     2009-11-02 14:32:11     2       19990   3
> 90      2009-11-02 14:32:11     2009-11-02 14:32:11     2       725     1
> 89      2009-11-02 14:32:10     2009-11-02 14:32:10     1       1250    1
> 88      2009-11-02 10:00:07     2009-11-02 10:00:07     2       19995   3
> 87      2009-11-02 10:00:07     2009-11-02 10:00:07     1       9612    3
> 86      2009-11-02 10:00:07     2009-11-02 10:00:07     2       725     1
> 85      2009-11-02 10:00:07     2009-11-02 10:00:07     1       1250    1
> 84      2009-11-02 09:59:47     2009-11-02 09:59:47     2       19995   3
> 83      2009-11-02 09:59:47     2009-11-02 09:59:47     1       9609    3
> 82      2009-11-02 09:59:47     2009-11-02 09:59:47     2       725     1
> 81      2009-11-02 09:59:47     2009-11-02 09:59:47     1       1250    1
> 80      2009-11-02 09:59:39     2009-11-02 09:59:39     2       19995   3
> 79      2009-11-02 09:59:39     2009-11-02 09:59:39     1       9609    3
> 78      2009-11-02 09:59:39     2009-11-02 09:59:39     2       725     1
> 77      2009-11-02 09:59:39     2009-11-02 09:59:39     1       1250    1
>
> I have spent over half the day trying to figure out how to pull the
> last inserted row for each domain_id, search_engine_id pair in
> CakePHP.
>
> Can anyone help me figure out how to do this within CakePHP?
>
> I really appreciate your time.
> Chad
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---