Zend: Join doesn’t work in my model

November 10, 2011 | In: php, web development, Zend Framework

Zend provides JOIN, joinLeft, joinRight keywords to join two or multiple tables.  you can make an sql object by calling select function of current model by:

$select = $this->getDbTable()->select();

Use below line to use JOIN terms in your SQL:

$select->setIntegrityCheck(false);

By default its integrity value set to True and it do not allow to use join with multiple tables. We set to False and then we can use JOIN.

Comment Form

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Categories

Latest comments


    Fatal error: Uncaught Error: Call to undefined function split() in /home4/nos/public_html/naveenos.com/wp-content/themes/smoker/functions.php:72 Stack trace: #0 /home4/nos/public_html/naveenos.com/wp-content/themes/smoker/sidebar.php(11): mdv_recent_comments() #1 /home4/nos/public_html/naveenos.com/wp-content/themes/smoker/single.php(47): include('/home4/nos/publ...') #2 /home4/nos/public_html/naveenos.com/wp-includes/template-loader.php(74): include('/home4/nos/publ...') #3 /home4/nos/public_html/naveenos.com/wp-blog-header.php(19): require_once('/home4/nos/publ...') #4 /home4/nos/public_html/naveenos.com/index.php(17): require('/home4/nos/publ...') #5 {main} thrown in /home4/nos/public_html/naveenos.com/wp-content/themes/smoker/functions.php on line 72