CODEWITHSUNDEEP
phpmysqlzend-framework
Yamuna
Yamuna

Reputation: 71

Zend - SELECT statement "AS"

I have the following query 

(select informed from evaluations where releases_id="1234") AS INFO

ZEND frameword query:

$get_details = $db->select()
                ->from(array('INFO'=>'evaluations'), 'informed')
                ->where('releases_id =?',"$row[id]");

The above gives 

SELECT `INFO`.`informed` FROM `evaluations` AS `INFO` WHERE (releases_id ='1214')

but I would like to get

(select informed from evaluations where releases_id="1234") AS INFO

Can anyone please guide me to build the right query?

Upvotes: 0

Views: 220

Answers (2)

Lialon
Lialon

Reputation: 1459

Starting from your request :

$get_details = $db->select()
            ->from(array('INFO'=>'evaluations'), 'informed')
            ->where('releases_id =?',"$row[id]");

Try this to rename your subquery, it should work :

$get_details = $db->select()->from(array('INFO' => $get_details))

Upvotes: 1

peterm
peterm

Reputation: 92795

I'm not an expert in Zend but you may try something along the lines of

$subquery = $this->select()
    ->from('evaluations'), array('informed')) 
    ->where('releases_id = ?', $row[id]);

$main = $this->select()
    ->from('info' => new Zend_Db_Expr('(' . $subquery . ')'));

$result = $this->fetchAll($main);

Upvotes: 0

Related Questions