$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);
$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