Active Record question

[eluser]Bondie[/eluser]

Code:

$get_rece = $this->db->query("SELECT `id`, `title`, `slug`, `category_id`, `user_id`, `price`, `date_start`, `date_end`, `description`, `images` FROM (`classifieds_listings`) WHERE `id` IN (".$comma_separated.") AND `date_end` > 1327857702 AND `date_start` < 1327857702 ORDER BY FIELD(`id`, ".$comma_separated.")");

This does the trick, producing:

SELECT `id`, `title`, `slug`, `category_id`, `user_id`, `price`, `date_start`, `date_end`, `description`, `images` FROM (`classifieds_listings`) WHERE `id` IN (3,7,2,6,1) AND `date_end` > 1327857702 AND `date_start` < 1327857702 ORDER BY FIELD(`id`, 3,7,2,6,1)