Assuming that translates to:
SELECT
Friend.*,
User.username,
User.avatar,
User.handler
FROM
friends AS Friend,
INNER JOIN users AS User
ON User.id = Friend.user_id
WHERE
Friend.status = 'approved' AND
(
(Friend.user_id = ':user_id') OR
(User.friend_id = ':user_id')
)
ORDER BY
Friend.requestTime ASC
LIMIT 0,5
I believe this may work, of course I haven't tested it, you may want
to read [1] and [2] to make the appropriate mods:
$condition = array (
"Friend.status" => "approved",
"or" => array (
"Friend.user_id" => $user_id,
"User.friend_id >" => $user_id
)
)
$this->Friend->bindModel(array(
'hasAndBelongsToMany' => array(
'FilterUsers' => array(
'className' => 'User',
'foreignKey' => false,
'conditions' => $conditions
))));
$this->Friend->find('all');
[1] http://book.cakephp.org/view/74/Complex-Find-Conditions
[2] http://book.cakephp.org/view/83/hasAndBelongsToMany-HABTM
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
