Zend_Db_Table_Abstract - How to do a SUM?

zend-framework zend-db zend-db-table
MEM picture MEM · Nov 24, 2010 · Viewed 7.2k times · Source

I can't find here: http://framework.zend.com/manual/en/zend.db.select.html any reference to SUM using mysql.

How can we perform a simple:

SELECT SUM(mark) as total_mark FROM `student`

Using Zend_Db_Table_Abstract ?

Tried:

this->select(SUM ('myintcolumn'))->from('mytable');

No luck. :(

Thanks, MEM

Answer

aletzo picture aletzo · Nov 24, 2010

did you try

this->select()->from('mytable', array('sum(myintcolumn) as sum'));

Related questions

Zend Framework: How to delete a table row where multiple things are true?

Normally, this would work for me: $db = Zend_Db_Table::getDefaultAdapter(); $where = $db->quoteInto('id = ?', $id); $db->delete('tablename', $where); but I have to match two ids. So I don't really know how to structure it. WHERE …

Read More
How do I add more than one row with Zend_Db?

I have an array with information which looks more or less like this: $data[] = array('content'=>'asd'); $data[] = array('content'=>'asdf'); And I want to add both entries into the Database. $db->insert('table', $data); does not …

Read More
Zend Framework: How to retrieve the id of the last inserted row?

I'm inserting a new row into my database with this code: $data = array( 'key' => 'value' ); $this->getDbTable()->insert($data); How can I get the row id of the this row that I just created?

Read More