Codeigniter DB Query

execute query

$results = array();
$table_name = '';
$sql = "";
$query = $this->db->query($sql);
$results = $query->result_array();

Get random record

$total_rows = 1000;
$table_name = HOMEPAGE_DATA_TABLE;
$query = $this->db->query('SELECT * FROM `'.HOMEPAGE_DATA_TABLE.'` WHERE `availability_instock` = 1 ORDER BY RAND() LIMIT '.NUMBER_OF_RANDOM_PRODUCTS);
$data['product']['random_products'] = $query->result_array();

Get random Record (super fast query)

$table_name = '';
$results = array();
$limit = 1;
$sql = "SELECT *
        FROM $table_name AS r1 JOIN
        (SELECT CEIL(RAND() *
        (SELECT MAX(id)
        FROM $table_name)) AS id)
        AS r2
        WHERE r1.id >= r2.id
        ORDER BY r1.id ASC
        LIMIT $limit;";

$query = $this->db->query($sql);
$results = $query->result_array();

Select ID Range

$sql = 'SELECT `image`
FROM `bf_products_inventory`
WHERE `id` BETWEEN '.$start_id.' AND '.$end_id;

$query = $this->db->query($sql);
$records = $query->result_array();

use $this in Helper (query database)

$CI =& get_instance();
$query = $CI->db->query($sql);