Tag Archives: MySQL

Database date between query build file in CodeIgnitor administrator

Here’s the path to DB file in CodeIgnitor admin end which contains query related stuff. Like building order, qhere and select blocks. One may want to do some debugging in this file. In this file i need to make no changes. Just for reference.

/administrator/system/database/DB_active_rec.php

Now here’s how once could make a BETWEEN query for a date field. I wanted records for last 30 days. Continue reading

A few notes on joining a MySQL table to itself to get unique combination of field data

Just a few notes on joining a MySQL table to itself to get unique combination of data stored in its fields.

Suppose we have a MySQL table named `keywords` having fields `word1`, `word2` and `word3`. Once we have got a few records inserted into this table we would want to show all possible combination of keywords stored in those fields. For example, a select query returns a following set of data: Continue reading