public function entityJoin($entity1, $entity2) { include_once 'EntityRelations.php'; $eRelations = new EntityRelations(); $joinArray = $eRelations->getJoins($entity1, $entity2); //var_dump('joinEntities' , $entity1 , $entity2); //var_dump('joinArray' , $joinArray); foreach ($joinArray as $join) { if ($join != null) { //if($join[1] != null && $join[2] != null && $join[3] != null && $join[4] != null ) $this->sqlArray['join'][] = array('table' => $join[2], 'jointype' => 'INNER', 'field1' => $join[1], 'field2' => $join[3], 'entity1' => $join[0], 'entity2' => $join[2], 'as' => $join['as']); } } }