DMZ 1.7.1 (DataMapper OverZealous Edition)

[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 ..

Thanks for your time