[eluser]alejandronanez[/eluser]
Hello Guys!
I need to do a Select using AR, but it doesn't work.
Here's the code.
Model:
Code:
function obtener_todos($number_items,$offset){
$this->db->select('field2, field3');
$query = $this->db->get('table',$number_items,$offset);
if($query->num_rows>0){
return $query;
}
}
Controller (part where I use $query variable):
Code:
$data['records'] = $this->area_en_nom_model->obtener_todos($config['per_page'],$this->uri->segment(3));
And finally my view:
Code:
echo $this->table->set_heading('COD_DESCRIPCION', 'DESCRIPCION');
echo $this->table->generate($records);
It always returns 3 columns, it's like
instead of 2 columns
Code:
SELECT field2 , field3 FROM table
.
IDK what's wrong.
Thanks everybody.
Ps.
I also tryed this on the model:
Model:
Code:
function obtener_todos($number_items,$offset){
$this->db->select('field2');
$query = $this->db->get('table',$number_items,$offset);
if($query->num_rows>0){
return $query;
}
}
But it returns field1(ID) and field2 , I need field2 and field 3.