Welcome Guest, Not a member yet? Register   Sign In
[Active Record] Order by field
#1

Hi there

I'm using CI 3.1.4 and have a problem with 'order by field'.

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);

 return $this->db->get();

I'm propably doing something wrong. Can anyone help me? Thanks in advance.
Reply


Messages In This Thread
[Active Record] Order by field - by boddah85 - 04-07-2017, 06:46 AM
RE: [Active Record] Order by field - by neuron - 04-07-2017, 07:27 AM



Theme © iAndrew 2016 - Forum software by © MyBB