Latest news
Home » SocialEngine » select query cannot join with another table zend framework

select query cannot join with another table zend framework

$select = $table->select()
->setIntegrityCheck(false)
->from($tableName)
->joinRight($subtableName, ‘`’.$subtableName.’`.`user_id` = `’.$tableName.’`.`user_id`’,array(‘resource_approved’,’user_approved’))
->where(‘`’.$subtableName.’`.`resource_id` = ?’, $resource->getIdentity());

Give the following sql statement for avoid  “select query cannot join with another table zend framework”  mysql error.

setIntegrityCheck(false)

 

Leave a Reply

x

Check Also

Get parameter value in socialengine or zendframework

Get parameter value in socialengine/zendframework $this->_getParam(‘id’, null) $this->getRequest()->getParam(‘fancybox’, null);