change a complicated query to Zend_Db_Select object

Question

I have a query which is a little complicated:

(SELECT category_id AS id, content_title AS title, content AS detail, 'content' AS type
 FROM category_content
 WHERE $where
 ORDER BY id DESC)
UNION
(SELECT news_id AS id, news_title AS title, news_detail AS detail, 'news' AS type
 FROM news
 WHERE $where
 ORDER BY id DESC)

How can i change this query to Zend_Db_Select object?

Bill Karwin · Accepted Answer · 2010-10-01 18:32:50Z

2

To build a UNION query with Zend_Db_Select, first build each subquery as individual Zend_Db_Select objects, and then union() them together:

$catSelect = $db->select()-> ... ;
$newsSelect = $db->select()-> ... ;

$unionSelect = $db->select()->union($catSelect, $newsSelect);

answered Oct 1, 2010 at 18:32

Bill Karwin

567k87 gold badges711 silver badges872 bronze badges

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

Collectives™ on Stack Overflow

change a complicated query to Zend_Db_Select object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related