Display Friends

[eluser]mStreet[/eluser]
Hehe alright, guess I just misunderstood you.

$this->db->last_query()

Code:

SELECT `users`.*, `friendships`.* FROM (`users`) JOIN `friendships` ON `friendships`.`user_id` = `users`.`user_id`

model friends

Code:

$query = $this
   ->db
       ->select('users.*, friendships.*')
    ->join('friendships', "friendships.user_id = users.user_id
    AND ( (friendships.user_id = " . $this->user->user_id . " )
    OR (friendships.requestee = " . $this->user->user_id . "))
    AND (friendships.status = 'accepted')")
    ->get('users');