Active Records Subquery |
[eluser]ibnclaudius[/eluser]
Is there a better way to do a subquery with Active Records? Here's my query: Code: return $this->db->select('a.id, a.name, a.url_segment, a.categories_id, (SELECT image FROM supplements WHERE subcategories_id = a.id ORDER BY RAND() LIMIT 1) AS supplements_image')
[eluser]Aken[/eluser]
No, there's not. Subqueries and active record aren't designed to get along.
[eluser]Otemu[/eluser]
You could use a library such as this one https://github.com/EllisLab/CodeIgniter/wiki/Subqueries |
Welcome Guest, Not a member yet? Register Sign In |