How to convert from Mysql query to Codeigniter syntax?

[eluser]Thorpe Obazee[/eluser]

Code:

SELECT lib_books.boo_id,
    COUNT(lib_books.boo_id)AS number ,
    lib_books.boo_title
FROM lib_borrowings bo
INNER JOIN lib_books
ON lib_books.boo_id=bo.boo_id
GROUP BY lib_books.boo_id;

assuming that your sql statement is correct, it should look like this.

Code:

$this->db->select('lib_books.boo_id,  lib_books.boo_title');
$this->db->select('COUNT(lib_books.boo_id)AS number', FALSE);
$this->db->join('lib_books', 'lib_books.boo_id = bo.boo_id', 'inner');
$this->db->group_by('lib_books.boo_id');
$this->db->get('bo');