Trying to get all of the offers I want to get all offer languages as one field.
Code: Select all
array [
'id' => string '11',
'name' => string '134',
'date' => string '01-12-2016',
'languages' => array(all language value from related table)
]
Code: Select all
$select = $this->getDbTable()->select()
->setIntegrityCheck(false)
->from(array('o' => 'offers'), array('o.*'))
->joinLeft(array('ol' => 'offer_language'), 'ol(.)id_offer = o(.)id', array('ol.*'));
$resultSet = $this->getDbTable()->fetchAll($select)
Zend Version: 1.11
Thanks for help.