[eluser]gowrav vishwakarma[/eluser]
heads off to you...
agreed i have to use guideline .. i am almost near what you said but major question
As per your said I can get all friends of John if he has its id in member_id and friends id in friend_id, what if any of his friend added him in his list then also he is Johns friend. can there be a simple workaround in Datamapper
since I am provided with database by my client this relation ship is in "jos_xshouts_members_has_friends" table with fields id | member_id | friend_member_id
as per guideline I have gone to this ...
Code:
class Member extends DataMapper{
var $table='users';
var $has_many=array(
'member'=>array(
'other_field'=>'friend_member',
'reciprocal' => TRUE,
'join_table'=>'jos_xshouts_members_has_friends'
),
'friend_member'=>array(
'class'=>'member',
'other_field'=>'member',
'join_table'=>'jos_xshouts_members_has_friends'
)
);
but $m=new Member();
$m->friend_member->get() gives nothing, I have also tried $m->member->get() .. but same ..