[eluser]Unknown[/eluser]
Hi,
im trying to execute a query containing several subqueries, some of them ending with "limit 1", but it looks like codeigniter is removing that part from the query.
This is an example of what im trying to do
$this->db->select('*');
$this->db->select('(select name from categories where id = articles.category_id limit 1) as category');
$this->db->from('articles')->get();
I think this is a bug.
Any help would be very apreciated.
Thanks.