Hey,
This is not Cake specific, but just posting here as I think this will
be useful for others as well. Here's my code:
$topLinks = $this->Vote->getTopRated();
$this->set('links',
$this->Link->findAll(array('Link.id'=>
$topLinks, 'Link.status'=>UC_STATUS_APPROVED)));
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
I've tried appending Order by NULL, but it wouldn't work. Can anyone
help?
Thanks,
Abhimanyu Grover
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
