Search code examples
CodeIgniter query() with unescaped single quotes in a single-quote SQL string gives a 1064 error...


phpmysqlcodeignitermodelescaping

Read More
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
Parameterized query error at column called "order" in CodeIgniter...


phpcodeigniterprepared-statementquotingreserved-words

Read More
CodeIgniter parameterized query with MATCH () AGAINST () expression breaks on column named "des...


phpcodeigniterprepared-statementquotingreserved-words

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


phpmysqlcodeigniterselectquery-builder

Read More
Raw SQL executed with mysql_query() returns no results in CodeIgniter but works in phpMyAdmin...


phpmysqlcodeigniter

Read More
How to popuplate a select field's options with query result data using CodeIgniter...


phpcodeignitermodel-view-controllerwhile-loopdrop-down-menu

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
Getting Sum of db field using join active record in codeigniter...


phpmysqlcodeigniterjoincodeigniter-2

Read More
Convert SQL containing JOINs, a subquery, GROUP BY and SUM() to CodeIgniter's active record...


phpcodeigniterjoinactiverecordsubquery

Read More
SELECT query to COUNT qualifying rows from an indirectly related table with CodeIgniter's active...


phpsqlcodeigniteractiverecordcount

Read More
how to count no of records in and display in view...


phpcodeignitermodel-view-controllercount

Read More
SELECT COUNT() per id with Codeigniter and send to view...


phpcodeignitercount

Read More
How to COUNT() the number of rows in a database table with CodeIgniter...


phpcodeignitercount

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
CodeIgniter Active Record - Get number of returned rows and get the sum...


phpmysqlsqlcodeigniter

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
Get final balance with latest transaction per account with CodeIgniterfetching data from the table...


phpmysqlcodeignitergroupingaggregate-functions

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


phpcodeignitermodel-view-controllersumquery-builder

Read More
How to present columnar totals in a CodeIgniter view's HTML table...


phparrayscodeignitersumcodeigniter-2

Read More
Codeigniter: Sum value of several columns...


phpcodeignitersum

Read More
How to count the number of rows with a date from a certain year in CodeIgniter?...


phpdatecodeigniterselectcounting

Read More
Get the sum of a column for the logged-in user with CodeIgniter's query builder...


phpcodeignitersessionsumquery-builder

Read More
BackNext