Loop inside a loop in controller.. help needed....:(

[eluser]Roy MJ[/eluser]
Ive tried out join function and an error is logging in.. The model is as follows:

Code:

function get_total($id)
    {
        $count=0;
        $getid = $id;
        $this->db->select('COUNT(friends.id) AS total');
        $this->db->distinct();
            $this->db->from('friends');
        $this->db->join('members','friends.member_id ='. $getid);
        $result_total = $this->db->get();
        if($result_total->num_rows()>0){
            $row    = $result_total->row();
            $count    =    $row->total;
        }
        return $count;
    }

The error is :

Code:

A Database Error Occurred

Error Number: 1054

Unknown column '13' in 'on clause'

SELECT DISTINCT COUNT(friends.id) AS total FROM (`friends`) JOIN `members` ON `friends`.`member_id` =`13`

I cant figure out why the error. 13 is actually the id thats getting passed.. Anyone..??