Sunday, 25 June 2017

44.selection in social engine

$propertyRequestTable =  Engine_Api::_()->getDbtable('propertyrequest', 'user');
   $propertyReq_select = $propertyRequestTable->select()
                     ->setIntegrityCheck(false)
                      ->from(array('prequest'=>'engine4_property_request',))
                      ->joinLeft(array('plist'=>'engine4_property_list',),'plist.id=prequest.property_id',array('property_name','rental_type','granted'))  
          ->where('prequest.id = ?', $applicationRequest_id);
   $propertyRequest = $propertyRequestTable->fetchRow($propertyReq_select);

No comments:

Post a Comment