How do I add more than one row with Zend_Db?

Question

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 add both entries. What am I doing wrong? Do I have to use Zend_ Db_Table?

$data = array('content'=>'asdf');
$db->insert('table', $data);

works of course

Answer 1

You can execute any SQL syntax you want -- including multi-row INSERT statements -- via the Zend_Db_Adapter_Abstract::query() method.

But methods of the Zend_Db_Table and Zend_Db_Table_Rowset classes don't have any support for inserting multiple rows in one go.