On Mon, Jun 9, 2008 at 12:45 PM, Abhimanyu Grover <[EMAIL PROTECTED]> wrote:
> > In first line, I'm trying to get Id's of all top rated links - which > comes from a bit complex algorithm. > In second line, I pass on those ids to findAll() which creates sql > statement like this: > > WHERE `Link`.`id` IN (1, 5, 7, 4, 3) > > Now problem is, I need them in same order as I've sent them in IN(..) > but mysql returns them ordering by id. i.e. 1, 3, 4, 5, 7 > You have to use ORDER BY FIELD(id, 1, 5, 7, 4, 3) ** I am sure you will figure out how to get cake to do it Tarique -- ============================================================= Cheesecake-Photoblog: http://cheesecake-photoblog.org PHP for E-Biz: http://sanisoft.com ============================================================= --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
