Solely COUNT(*) from Zend_DB Select Statement (Subquery)

Question

I'm trying to wrap a count(*) query around an existing Zend_Db select statement, but all I was able to get is:

SELECT `t`.*, COUNT(*) AS `TotalRecords` FROM (SELECT ....) AS `t`

However I like to get rid of the t.* as I only need the count(*).

This is my code so far:

$db = Zend_Registry::get('db');
$select = $dbmodel->getSomething(); //zend select object
$outterSelect = new Zend_Db_Select($db);
$outterSelect->from($select)->columns(array('TotalRecords' => new Zend_Db_Expr('COUNT(*)')));
echo $outterSelect->__toString();

Any help is appreciated!

Aurelio De Rosa · Accepted Answer · 2012-04-01 11:28:08Z

5

You can simply write:

$outterSelect->from($select, 'COUNT(*) as TotalRecords');

answered Apr 1, 2012 at 11:28

Aurelio De Rosa

22.2k8 gold badges51 silver badges71 bronze badges

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

3 Comments

dforce Over a year ago

would it also be possible to get the result by only using $select. that means without $db?

Aurelio De Rosa Over a year ago

If your mobel is extend Zend_Db_Table, you can do something like $model->select()->from->(...)

dforce Over a year ago

something like this $res = $doc->select()->from($select, 'COUNT(*) as rowcount')->fetchAll()->toArray(); doesn't work for me. fetchAll() is not known in this case.

Collectives™ on Stack Overflow

Solely COUNT(*) from Zend_DB Select Statement (Subquery)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related