Select Qry And Join Ci


function mas_rights()
{

$this->db->select('*');
$this->db->from('mas_rights');
$query=$this->db->get();
return $query->result();  //mas_rights mas_model
}

function mas_rights_model()
{
$this->db->from('mas_rights');
$this->db->join('mas_model', 'mas_rights.rights_id = mas_model.model_id');
$query = $this->db->get();
return $query->result();
}

Comments