[Active Record] Order by field

I suggest u to output your query as a string and try that query in mysql workbench, that way is easier to see errors

PHP Code:

$this->db->where_in('table.column',$artIDs);
$order = sprintf('FIELD(table.column, %s)', implode(', ', $artIDs));
$this->db->protect_identifiers(FALSE)->order_by($order);
$this->db->limit((int)$limit,(int)$start);


$sql = $this->db->get_compiled_select();
echo $sql;
return $this->db->query($sql);