[eluser]nonamez[/eluser]
I faced some problem with active record as it automatically adds accents. For example i need to use this
Code:
ORDER BY FIELD(sites.ID, 120, 27, 119)
, so i do it like
Code:
$this->db->order_by('FIELD(sites.ID, '.implode(', ', $sites).' )');
, but getting
Code:
ORDER BY FIELD(`sites`.`ID`, `120`, `27`, `119`)
I also tried to add apostrophes, but nothing has changed. Is there any way to do my query or i need to rewrite it as a simple query? And if so how to escape all values without loop (array_map) ?