string based custom ordering in active record

[eluser]TheFuzzy0ne[/eluser]
Please edit your post and put your code into [code][/code] tags.

F'ugly code:

$this->db->select(‘i.id, condition, description, created_at, updated_at, category, latitude, longitude, status,
d.device_token, d.facebook, d.preferred, d.email, d.phone’);
$this->db->select(“CONCAT( ‘$url’, image_url_original ) AS image_url_original”);
$this->db->select(“CONCAT( ‘$url’, image_url_mid ) AS image_url_mid”);
$this->db->select(“CONCAT( ‘$url’, image_url_thumb ) AS image_url_thumb”);

$this->db->from(‘item as i’);
$this->db->join(‘device as d’, ‘i.device_id = d.device_token’);

$this->db->where(‘created_at > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 24 HOUR)’);
$this->db->where(‘i.status’,‘shared’);

Neater code:
[code]

Code:

$this->db->select(‘i.id, condition, description, created_at, updated_at, category, latitude, longitude, status,          
    d.device_token, d.facebook, d.preferred, d.email, d.phone’);
$this->db->select(“CONCAT(  ‘$url’,  image_url_original ) AS image_url_original”);
$this->db->select(“CONCAT(  ‘$url’,  image_url_mid ) AS image_url_mid”);
$this->db->select(“CONCAT(  ‘$url’,  image_url_thumb ) AS image_url_thumb”);

$this->db->from(‘item as i’);
$this->db->join(‘device as d’, ‘i.device_id = d.device_token’);

$this->db->where(‘created_at > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 24 HOUR)’);
$this->db->where(‘i.status’,‘shared’);

[/code]