Search code examples
Get the sum of a column for the logged-in user with CodeIgniter's query builder...


phpcodeignitersessionsumquery-builder

Read More
How to execute a SELECT SUM() query using CodeIgniter's query builder methods...


phpcodeigniterselectsumquery-builder

Read More
SUM() values from a single column using CodeIgniter's query builder...


phpmysqlcodeignitersumquery-builder

Read More
SELECT SUM() of column values from qualifying rows using CodeIgniter's query builder...


phpmysqlcodeignitersumquery-builder

Read More
Select and count record from database using codeigniter active query method...


phpcodeigniterjoincountquery-builder

Read More
SELECT COUNTs of specific column values from qualifying rows in a JOINed table using CodeIgniter&#39...


phpcodeigniterjoinaggregate-functionsquery-builder

Read More
CodeIgniter Check if database is wrong...


phpmysqldatabasecodeigniterconfiguration

Read More
Using group_start with codeigniter. Need OR instead of AND...


phpcodeigniterwhere-clausequery-builderlogical-grouping

Read More
( (Where and Where) OR (Where and Where) ) CodeIgniter...


phpmysqlcodeigniterquery-builderlogical-grouping

Read More
How to check if a parenthetical group is open in CodeIgniter's query builder - group_start() was...


phpmysqlcodeigniterquery-builderlogical-grouping

Read More
ORDER BY a column DESC except swap the first and second rows in CodeIgniter...


phpmysqlcodeignitersql-order-by

Read More
ORDER BY a column with CodeIgniter...


phpmysqlsortingcodeignitersql-order-by

Read More
ORDER BY a specific value in a column using CodeIgniter's query builder...


phpcodeignitercomparisonsql-order-byquery-builder

Read More
CodeIgniter: CRUD order_by error...


phpmysqlcodeignitercrud

Read More
How chain an order_by() call to a CodeIgniter query built fully by get_where()...


phpcodeignitersql-order-byquery-buildermethod-chaining

Read More
"Call to undefined method CI_DB_mysql_result::order_by()" when chaining CodeIgniter's ...


phpcodeigniterquery-builder

Read More
Convert SELECT query with GROUP BY and ORDER BY COUNT(*) to CodeIgniter's active record...


phpmysqlcodeignitersql-order-byquery-builder

Read More
SELECT WHERE a group of OR IN () conditions AND a group of OR LIKE conditions using CodeIgniter'...


phpcodeigniterwhere-clausesql-likewhere-in

Read More
SELECT query with WHERE, WHERE IN, LIKE, AND, and OR expressions using CodeIgniter's query build...


phpcodeigniterwhere-clausequery-builderlogical-grouping

Read More
Passing an associative array to CodeIgniter's where_not_in() is not rendering the WHERE NOT IN e...


phpcodeignitercodeigniter-3notincodeigniter-query-builder

Read More
SELECT rows from a table WHERE the id is not found in a second table using CodeIgniter's query b...


phpcodeigniterquery-buildernotinanti-join

Read More
How to append a LIMIT clause to a raw MySQL query in CodeIgniter...


phpmysqlcodeigniterlimit

Read More
codeigniter order by desc not working properly for more then 2 or 3 digits...


phpmysqlcodeignitersql-order-bynatural-sort

Read More
SELECT all rows FROM multiple tables in one trip to the database using CodeIgniter's query build...


phpmysqlcodeignitercodeigniter-3query-builder

Read More
How to remove duplicate values from GROUP_CONCAT() in CodeIgniter's select()...


phpmysqlcodeigniterquery-buildergroup-concat

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


phpcodeignitergroup-byquery-buildercounting

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


phpcodeigniterselectquery-builderquoting

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


phpcodeigniterwhere-clausequery-builderlogical-grouping

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


phpcodeigniterwhere-clausequery-builderlogical-grouping

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


phpcodeigniterwhere-clausequery-builderlogical-grouping

Read More
BackNext