Zend_Db_Select with variable assignment and subqueries

Question

I'm having a rough time figuring out where to start with getting this query into a Zend_Db_Select. I have never worked with variables assignment and subqueries in Zend:

SELECT
    @current_continent := stats_geo_continent.id AS `continent_id`,
    (SELECT GROUP_CONCAT(code) from stats_geo_country WHERE stats_geo_country.continent = @current_continent) AS `group`,
    stats_geo_country.code
FROM
    stats_geo_continent
INNER JOIN
    stats_geo_country ON stats_geo_country.continent = stats_geo_continent.id;

If it is not needed, maybe use a $db->query(). You could also create a view in your database and make a model for it. I think it would be faster and more efficient than using Db_select. — Marcin
– Marcin, Commented Feb 16, 2011 at 11:35

Community · Accepted Answer · 2017-05-23 11:33:16Z

1

I think it will be possible when you use Zend_Db_Expr for your variable assignments. For subgqueries you can use second Zend_Db_Select object as a part of main object - maybe that link will help you.

edited May 23, 2017 at 11:33

CommunityBot

11 silver badge

answered Feb 16, 2011 at 18:11

Radek

8,3614 gold badges34 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Zend_Db_Select with variable assignment and subqueries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related