Q:The SQL query in my web application(PHP/MySQL + Zend) uses a number of parameters to build the search query. However, the records fetched should be grouped by two columns to get sub totals. WITH ROLLUP seems to be a good solution to find subtotals, but Zend_Db_Select doesn't support this modifier. Is there any work around?
A: $select->from(array('t1' => 'table1'))
->where("where");
->group("(field1) WITH ROLLUP");
$select->from(array('t1' => 'table1'))
->where("where");
->group("(field1) WITH ROLLUP");