Archives for the Month of March, 2010

join-Statements mit Zend_DB

join-Statements mit Zend DB: /* * $db = a valid Zend_DB resource * table1: foo (short: t1) * table2: bar (short: t2) * columns: column1, column2, column3 */ $select = $db->select() ->from( array(‘t1′ => ‘foo’), // table name array(‘t1.column1′, ‘t1.column2′, ‘t1.column3′)) // selected columns ->join( array(‘t2′ => ‘bar’), ‘t1.column1 = t2.column1′) // JOIN bar t2 [...]