GROUP BY column prefix and COUNT() per group with CodeIgniter's query builder...

Writing a SUBSTRING() call in CodeIgniter's select() method renders SQL with corrupted quotes...

CodeIgniter query builder with multiple OR LIKE conditions on a single column and other separated AN...

CodeIgniter query WHERE clause with enclosed OR conditions and AND other conditions...

SELECT rows with specific combinations of values in two columns using CodeIgniter's query builde...

JOIN two tables using a linking table with CodeIgniter's query builder...

Get all records created more than 24 hours ago using CodeIgniter's query builder...

GROUP BY and LIMIT per group and SELECT limited aggregate values per group with CodeIgniter's qu...

CodeIgniter query builder script to GROUP BY two columns, then COUNT(), SUM(), and CONCAT() in the S...

unable to count the result with a condition using codeigniter query...

Output the results of the SQL query in CodeIgniter is not displaying...

Get unlimited row count and paginated results from the database using CodeIgniter...

How to get the SQL string from $this->db->insert('history', $data) is building and sen...

Using count_all_results or get_compiled_select and $this->db->get('table') lists table...

How to count the number of records in a database table meeting a condition using CodeIgniter's q...

SELECT rows WHERE column value matches values in a flat array using CodeIgniter's query builder...

JOIN tables and create a comma-separated string of aggregate data with CodeIgniter's query build...

SELECT all rows and count rows using CodeIgniter's query builder with just one method to the dat...

CodeIgniter's count_all() doesn't respect the conditions in the built WHERE clause...

GROUP BY and COUNT() with and without a condition using CodeIgniter's query builder...

Join two tables with a one-to-many relationship without duplicating each parent record with CodeIgni...

SELECT rows with current term number AND the latest N rows with the previous term number using CodeI...

How to write a CASE statement in a WHERE clause using CodeIgniter's query builder...

Codeigniter query error: "In aggregated query without GROUP BY, expression #1 of SELECT list co...

CodeIgniter query builder script to GROUP BY gender and COUNT() rows in a table...

Retrieve records from database by passing an array...

How to use a column of results from one query in the next query using CodeIgniter's query builde...

What is the purpose of the CodeIgniter's get() active record method?...

How to execute a SELECT query via CodeIgniter's query builder without passing a statically true ...

Refactor Codeigniter model to custom calculate a dynamic set of column values for a dynamic set of i...