Something like this may help: SELECT domain_id, search_engine_id, MAX(id) FROM table GROUP BY domain_id, search_engine_id
Regards, Pablo Viojo [email protected] http://pviojo.net ¿Que necesitas? http://needish.com On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
