How execute query with subqueries in zend framework

Question

Hi I need write this sql with Zend_Db_Select, but I dont know how I can write subqueries. I would appreciate any help. Thanks.

SELECT * FROM advert WHERE categoryId
           IN (
             SELECT id
              FROM `tree`
              WHERE `lft` BETWEEN 
               (SELECT lft FROM tree WHERE id = '2') AND 
               (SELECT rgt FROM tree WHERE id = '2'))

Tim Stone · Accepted Answer · 2011-02-08 09:33:22Z

1

// create the main query
$select = new Zend_Db_Select();

//create the subquery
$subSelect = new Zend_Db_Select();

// using the subquery in main query
$select->where('table.field IN(?)', $subSelect->assemble());

edited Feb 8, 2011 at 9:33

Tim Stone

19.2k6 gold badges58 silver badges66 bronze badges

answered Feb 7, 2011 at 15:28

Rafael Armenio

363 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:47:45Z

0

Maybe this answer will help you decide between using standard sql queries and zf-made ones.

I myself don't recommend using Zend_Db_Select for complex and scarcely used queries.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Feb 7, 2011 at 14:35

nevvermind

3,3822 gold badges40 silver badges45 bronze badges

Collectives™ on Stack Overflow

How execute query with subqueries in zend framework

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related