Zend Framework select in select Zend_Db_Table

Question

does anyone know how to do a nested query such as "SELECT * FROM (SELECT * FROM table LIMIT 0,12) table ORDER BY rand ()", using Zend_Db_Table?

Maybe this help: stackoverflow.com/questions/1340564/…

user2472312
– user2472312

2014-02-20 21:01:08 +00:00
Commented Feb 20, 2014 at 21:01 — user2472312
– user2472312, Commented Feb 20, 2014 at 21:01

Community · Accepted Answer · 2017-05-23 12:28:43Z

0

It is not supported in direct way. You can try some workarounds, but still the best way will be to get db adapter and query manually like:

$db = Zend_Db_Table::getDefaultAdapter();
$db->query('SELECT * FROM (SELECT * FROM table LIMIT 0,12) table ORDER BY rand ()');

If you want try workarounds like creating 2 queries and mixing them, passing subquery as ->from() part etc. have a look at this topic Zend_Db_Table subquery

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Feb 20, 2014 at 20:59

MSadura

1,04213 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Zend Framework select in select Zend_Db_Table

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