Quote:Just name your model ‘juser’, and in that model set $this->table to ‘users’ make override the models table name.
its not that simple.. you have not noticed the relative field is UID not UID_id ... some how i have managed it to work now second problem .. and this can be helpful to other also
I have a table members, and the members can have another members as friends
its in another table stored as
id | members_id | friends_members_id |approved status
all good from one point "get all friends of member 87"
but the point is in this social application a member can be at members_id as he added a friend or he can be at friends_members_id as his friend added him. now how to get all friends of a member and even only those who are approved !!!