Is there anyway to get all the row information with all those ids or does it require another query to get row details for returned ids?
Thanks, Chad On Mon, Nov 2, 2009 at 6:36 PM, Pablo Viojo <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
