Search code examples
CodeIgniter's update() query builder method corrupts the rendered SQL with backticks around each...


phpmysqlcodeigniterquery-builderquoting

Read More
MySQL query fails after table qualifier on alias in CodeIgniter's select() method...


phpmysqlcodeigniteraliasquery-builder

Read More
Why does my CodeIgniter model method return no results?...


phpmysqlcodeigniterselectquery-builder

Read More
How to filter database table results to the last 12 hours using CodeIgniter's query builder...


phpmysqlcodeignitertimestampquery-builder

Read More
Convert raw MySQL query with SUM() expressions containing multiple conditions to CodeIgniter's q...


phpmysqlcodeignitersumquery-builder

Read More
Why is my CodeIgniter SELECT SUM() query returning 1 row when there should be more?...


phpmysqlcodeigniteraggregate-functionsquery-builder

Read More
GROUP BY one column, SUM() another column, and show both columns in the result using CodeIgniter&#39...


phpcodeignitergroup-bysumquery-builder

Read More
SELECT SUM() of multiplied column values from JOINed table with CodeIgniter's query builder...


phpcodeigniterjoinsumquery-builder

Read More
SELECT query with conditional expression in SUM() is rendered with incorrect backticks using CodeIgn...


phpmysqlcodeigniterquery-builderquoting

Read More
SELECT users and COUNT() their total votes sorted with largest totals first using CodeIgniter's ...


phpcodeignitergroup-bycountquery-builder

Read More
Multiply two columns within a CodeIgniter select_sum() call...


phpcodeignitersumquery-buildermultiplication

Read More
How to SUM() two multiplied column values with CodeIgniter's query builder...


phpmysqlcodeignitersumquery-builder

Read More
How to get the sum of database table column in CodeIgniter...


phpcodeignitermodel-view-controllersumquery-builder

Read More
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
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 specific value in a column using CodeIgniter's query builder...


phpcodeignitercomparisonsql-order-byquery-builder

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 query with WHERE, WHERE IN, LIKE, AND, and OR expressions using CodeIgniter's query build...


phpcodeigniterwhere-clausequery-builderlogical-grouping

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
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
BackNext