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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
