在zend中执行查询返回null

Question

我直接在phpmyadmin中运行此查询，它完全返回结果！ 但是当我在我的PHP脚本运行此查询，它返回NULL

，这是我的DB类：

class Product extends Places_Db_Table_Row_Observable { 
    protected $_name = 'product'; 
    PUBLIC function getMaxSubcatProduct() 
    { 


     $query = $this->getAdapter()->query("select max(c) AS maxcount,id from (select COUNT(*) as c 
        ,product_sub_category_id as id from product group by product_sub_category_id) as max "); 
     $res = $query->fetchAll(); 
     return $res; 
    } 
} 

Answer 1

这是我的错！我得到了下述结果在我的脚本是这样的：

echo $this->masterMenu["id"]; 

但正确的做法是：

foreach ($this->masterMenu as $key => $value) 
        { 
         $masterMenu = $value['id']; 
        }