query problem

[eluser]MMCCQQ[/eluser]
hi

i workin in a friend system. i got this problem
i got two table SQL

friends_add - id - id_user - friends - added

member - id - username - avastar

so i want get de Request list of a X id. and get de Username and avastar with his id.

i do this;

CONTROLLER
$id = my id ; ex : 1

Code:

$this->db->where('friends',$id);
        $qery = $this->db->get('friends_add');
        if($qery->num_rows() > 0)
        {
            
            foreach ($qery->result() as $row){
                $this->db->where('id',$row->id_user);
            $query = $this->db->get('member');
            }
                $side['friends'] = $query->result();

this code just gimme one friend request but i got two request. i dont know what happed!
VIEW

<?php foreach($friends as $row2):?>
<img width="60" height="60" src="/&lt;?=$row2->avastar;?&gt;">
&lt;?=$row2->username;?&gt;

[eluser]obiron2[/eluser]
friends_add - id - id_user - friends - added

member - id - username - avastar


Assuming friends_add.friends hold the X-ref to member.ID


To select all the member.ID and member.avastar:

Code:

SELECT  friends_add.friends AS friendID, member.username as Name, member.avastar AS avastar
FROM    friends_add
  JOIN  member ON friends_add.friends = member.ID
WHERE   friends_add.id_user = $myuserID

By using the AS alias, you change the propery names in the result object which makes the data easier to work with.

obiron