clear active record

[eluser]Cesar Kohl[/eluser]
To load everything on a table, use this code:

Code:

$query = $this->db->get('mytable');

Read the User Guide to have more information: http://ellislab.com/codeigniter/user-gui...ecord.html

You need to put the query in different strings:

Code:

$author = 'Cesar';
$this->db->select('id_author');
$this->db->where('name',$author);
$query_id_author = $this->db->get('authors');

$query_id_author->result();

$this->db->select('id_author');
$this->db->where('lastname','Kohl');
$query_id_author2 = $this->db->get('authors');

$query_id_author2->result();

At least is what I do and I never had your problem.