Welcome Guest, Not a member yet? Register   Sign In
QueryBuilder inside
#6

I'm not sure if this is the best way but I've been using queryBuilder to make the sub query then a different instance for the outer query.

PHP Code:
$subqueryBuilder $this->db->table('cs_web_display');
$subqueryBuilder->select('site_id');
...
$subquery $subqueryBuilder->getCompiledSelect(); 

and then plug $subquery into your outer $builder
Reply


Messages In This Thread
QueryBuilder inside - by objecttothis - 05-06-2024, 03:31 AM
RE: QueryBuilder inside - by kenjis - 05-06-2024, 03:47 AM
RE: QueryBuilder inside - by objecttothis - 05-06-2024, 04:35 AM
RE: QueryBuilder inside - by kenjis - 05-07-2024, 02:09 AM
RE: QueryBuilder inside - by xsPurX - 05-07-2024, 07:11 AM
RE: QueryBuilder inside - by objecttothis - 05-07-2024, 08:50 AM



Theme © iAndrew 2016 - Forum software by © MyBB