如何在CodeIgniter中创建Join Query模型

How to write join query in codeigniter... I want only model like this Select query-

public function getData($col, $table, $where = array())
{
        $this->db->select($col);
        $this->db->from($table);
        $this->db->where($where);
        $query = $this->db->get();
        $result = $query->result();

        return $result;
}

Plz help

$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');

http://ellislab.com/codeigniter/user-guide/database/active_record.html#select Please go through the user guide before posting it on stackoverflow

join query is there..

try this

$this->db->join('second_table', 'second_table.id = first_table.id');

try like this

$this->db->select('*');
$this->db->from('first_table');
$this->db->join('second_table', 'second_table.col_name = first_table.col_name');
$query=$this->db->get();
if($query->num_rows()>0){
return $query->result_array();
}

for joining table you may use join() methods.

$this->db->from(table1)
$this->db->join('table2','table1.id=table2.table1_id','join options');

on condition means in which condition you want to join tables . Join options is optional. Join Options are: left, right, outer, inner, left outer, and right outer