[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.