'active records' mysql query

[eluser]changereturnssuccess[/eluser]
I have a query, to generate comments, but I can not generate a pagination correctly, the question is,

How can I make this same query using 'active records' for this query?

Code:

$sql = ("SELECT comentarios.comentario,  usuarios.nick FROM comentarios, noticias, usuarios WHERE comentarios.id_nodo = noticias.id AND noticias.id = ? AND comentarios.id_usr = usuarios.id AND comentarios.estado = 1 LIMIT ?, ?");

$loscomentarios['datos_com'] = $this->db->query($sql, array((int)$this->uri->segment(3),(int)$this->uri->segment(4), (int)$config['per_page']));
    
    $this->load->view('comentarios/listado', $loscomentarios);

thanks

[eluser]theprodigy[/eluser]
[quote author="changereturnssuccess" date="1269125989"]I have a query, to generate comments, but I can not generate a pagination correctly, the question is,

How can I make this same query using 'active records' for this query?

Code:

$sql = ("SELECT comentarios.comentario,  usuarios.nick FROM comentarios, noticias, usuarios WHERE comentarios.id_nodo = noticias.id AND noticias.id = ? AND comentarios.id_usr = usuarios.id AND comentarios.estado = 1 LIMIT ?, ?");

$loscomentarios['datos_com'] = $this->db->query($sql, array((int)$this->uri->segment(3),(int)$this->uri->segment(4), (int)$config['per_page']));
    
    $this->load->view('comentarios/listado', $loscomentarios);

thanks[/quote]

You mean like:

Code:

$this->db->select('comentarios.comentario,  usuarios.nick');
$this->db->from('comentarios');
$this->db->join('noticias','comentarios.id_nodo = noticias.id');
$this->db->join('usuarios','comentarios.id_usr = usuarios.id');
$this->db->where('noticias.id',(int)$this->uri->segment(3));
$this->db->where('comentarios.estado',1);
$this->db->limit((int)$config['per_page'], (int)$this->uri->segment(4));

This may not be exact, but if it isn't, will at least give you a good head start.
This is just an active record version of your query. The only difference is I used joins for the tables instead of adding them to the from and where clauses.

[eluser]changereturnssuccess[/eluser]
thanks for the quick response

I have solved by reading the user guide

Code:

//comentarios
    
$where = 'comentarios.id_nodo = noticias.id AND comentarios.id_usr = usuarios.id AND comentarios.estado = 1';
$this->db->where('noticias.id',$id);
$this->db->where($where);
$query = $this->db->get('comentarios, usuarios, noticias');
$variables['datos_com'] = $query;
$this->load->view('comentarios/listado', $variables);

    //comentarios

also thank you very much