Welcome Guest, Not a member yet? Register   Sign In
Help -> Doing a Select using Active Record
#1

[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
Code:
SELECT * FROM table
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.
#2

[eluser]flaky[/eluser]
try this
Code:
$query = $this->db->get('table',$number_items,$offset)->result_array();




Theme © iAndrew 2016 - Forum software by © MyBB