Zend How to create a left join

Question

How to enable this left connection request:

select advertisercontest.*, advertiseraccount.advertiserid, advertiseraccount.companyname from advertisercontest left join advertiseraccount on advertiseraccount.loginid = advertisercontest.loginid where advertisercontest.golive is not NULL; 

to the left connection in Zend?

Answer 1

You can do the following:

  $db = Zend_Db_Table::getDefaultAdapter(); $select = $db->select(); $select->from('advertisercontest', '*') ->joinLeft( 'advertiseraccount', 'advertiseraccount.loginid = advertisercontest.loginid', array('advertiseraccount.advertiserid', 'advertiseraccount.companyname') ) ->where('advertisercontest.golive is not NULL');; $result = $db->fetchAll($select); var_dump($result); 

Hope all is well.