Display Friends

[eluser]aquary[/eluser]
Just to make it easier to read >_>

Code:

function friends()
{
    // You can merge the join and where together,
    // which is faster for the query since your main table here is "users".
    // Putting where somewhere else would slow it down.
    $query = $this->db
    // you could also try running this part as a single query as see if the result is valid
    ->join('friendships', "(friendships.user_id = users.user_id)
          AND (
            (friendships.user_id={$this->user->user_id})
             OR (friendships.friend_id={$this->user->user_id})
          )
          AND (friendships.status='accepted')
      ")
    // Since I don't know how you store login time, I put it this way. The last active is a unix timestamp
    // The where will filter only those who has done something in the last 5 minutes
    ->where('users.last_active>='.time()-300, NULL, FALSE)
    ->get('users');
  return $query->result();
}

...
Actually, I didn't even know yet what is your current result >_>?

edit: change the where condition