How to produce an array from a CodeIgniter query result object...

Database Design w/ Foreign Keys Question...

PHP Upload image to mysql database using PDO?...

Two Joins and a Where clause...

Insert picture into database using php...

Checking for nulls in CASE expression...

MySQL delete first row when new is added when at 15 rows...

Subtract from SUM in CASE expression...

Sum of three columns which is populated using case expression...

SUM 2 values in a CASE expression...

How to format a query result set as a JSON string...

How to prepare and present grouped database data with CodeIgniter...

How to group database rows and sum a column of values per group...

Getting the latest record in CodeIgniter using Group_by...

MySQL compound primary key duplicate entry error even though there is no duplicate entry...

How to compare with null in the query?...

SELECT rows which have specified pairs of column values using CodeIgniter's query builder...

order_by() and limit() called after update() are rendered in a subsequently built query in CodeIgini...

Why can I add null value to primary key in SQLite?...

MySQL procedure insert if foreign key not exist...

Complex mysql query. Return as multiple rows as apposed to single row...

Find identical aggregated combinations from pivot table in SQL...

How to prevent a duplicate name from a form submission with CodeIgniter's validation...

Duplicate rows CodeIgniter...

How to SELECT rows from two tables which have a parent-child relationship and print the data in grou...

INSERT NOW() into database row with CodeIgniter's query builder...

Auto update DATETIME column on insert with SQL?...

INSERT current datetime with NOW() using CodeIgniter's query builder...

SELECT rows matching a submitted id and having a datetime on a submitted date with CodeIgniter...

SELECT row with latest date value earlier than the current day using CodeIgniter's query builder...