Search code examples
How to get child data from one table per parent in another table and display as a two-tiered list wi...


phpcodeignitermodel-view-controllerparent-childquery-builder

Read More
Passing a string of WHERE conditions to CodeIgniter's get_where() method renders an invalid quer...


phpmysqlcodeigniterwhere-clausequery-builder

Read More
SELECT query WHERE NOT IN a subquery using CodeIgniter's Query Builder methods...


phpcodeignitersubqueryquery-builderwhere-in

Read More
SELECT rows from the database WHERE date is in the current week with CodeIgniter's Query Builder...


phpdatecodeigniterquery-builderdate-range

Read More
Codeigniter - How to get records from database where one fields value is more than another?...


phpmysqlcodeigniterwhere-clausequery-builder

Read More
CodeIgniter Query Builder WHERE a column value is greater than another column value...


phpcodeigniterwhere-clausecomparisonquery-builder

Read More
SQL join in CodeIgniter with Active Record...


phpcodeigniterjoinone-to-manyquery-builder

Read More
Show data codeigniter from joining table...


phpcodeignitermodel-view-controllercodeigniter-3query-builder

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


phpcodeigniterpaginationcodeigniter-3query-builder

Read More
How to avoid repeating rows when JOINing a one-to-many table with Codeigniter query builder...


phpcodeigniterjoinone-to-manyquery-builder

Read More
Explain this CodeIgniter Query Builder script which calls: select(), where(), join(), order_by(), an...


phpmysqlcodeigniterjoinquery-builder

Read More
How to do a NATURAL JOIN with multiple tables using CodeIgniter Query Builder...


phpmysqlcodeigniterquery-buildernatural-join

Read More
Mentioning the same table in CodeIgniter's from() and get() query builder methods incorrectly sh...


phpmysqlcodeigniterjoinquery-builder

Read More
Call to undefined method CI_DB_mysqli_driver::groupBy()...


phpcodeignitergroup-bycodeigniter-3query-builder

Read More
How to SELECT all data from a database table with CodeIgniter's query builder methods...


phpcodeigniterselectquery-builder

Read More
How to find out if an UPDATE query was successfully executed...


phpcodeignitersql-updatequery-builderrows-affected

Read More
How to return a single column value from a single row of a CodeIgniter query...


phpcodeigniterselectquery-builderresultset

Read More
Return both query result and num rows...


phpcodeigniterquery-builderresultsetcounting

Read More
Pass the number of qualifying rows from the model to the view in CodeIgniter...


phpcodeignitermodel-view-controllerquery-buildercounting

Read More
Single quotes in DATE_FORMAT() within a CodeIgniter select() call using single quotes emits a parse ...


phpcodeigniterquery-builderquotingparse-error

Read More
CodeIgniter JOINed tables returning results which should be disqualified by WHERE condition...


phpcodeigniterjoinwhere-clausequery-builder

Read More
Codeigniter SELECT query with multiple join() method calls results in duplicated rows...


phpcodeigniterjoinduplicatesquery-builder

Read More
How to GROUP BY an aliased CONCAT() value using CodeIgniter's query builder...


phpcodeigniteraggregate-functionsaliasquery-builder

Read More
How to avoid repeating parent rows when JOINing a one-to-many table with Codeigniter query builder...


phpcodeigniterjoinaggregate-functionsquery-builder

Read More
Adding a CodeIgniter join() method call to a working query builder script emits an error...


phpmysqlcodeigniterjoinquery-builder

Read More
How to SUM a column's values withing a date range with CodeIgniter's query builder...


phpcodeignitersumquery-builder

Read More
How to join tow times the same table?...


phpcodeigniterjoinquery-buildername-collision

Read More
Codeigniter how to echo more than one INNER JOIN from same table...


phpcodeigniterinner-joinquery-buildername-collision

Read More
Codeigniter MySQL a Join Query with a column name collision in the results...


phpmysqlcodeigniterquery-buildername-collision

Read More
How to fetch multiple values from a database using multiple ids with CodeIgniter...


phpcodeigniterselectcodeigniter-3query-builder

Read More
BackNext