Any idea how to use this approach with pagination? Chad
On Mon, Nov 2, 2009 at 7:11 PM, Pablo Viojo <[email protected]> wrote: > You can do something using subqueries (but if you're quering the same table > on main and sub query, it will not perform well) > I recommend to do two queries instead. > Regards, > > Pablo Viojo > [email protected] > http://pviojo.net > > ¿Que necesitas? > http://needish.com > > > On Mon, Nov 2, 2009 at 8:49 PM, Chad Casselman <[email protected]> wrote: >> >> 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 -~----------~----~----~----~------~----~------~--~---
