problem with an sql JOIN

**derrida** · 03-13-2010 07:32 AM

hi

i need to join 2 tables. i cannot make it the zend way so i decided to use regular sql, like so. in my model i have this method:

Code:

    public function getallposts()
    {
        $select = "SELECT posts.id,posts.category_id,posts.date,categories.id,categories.title 
 FROM posts LEFT JOIN categories 
	ON posts.category_id = categories.id";
        
        $result = $this->fetchAll($select);
        
        return $result;
    }

i get this error:
Message: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

what am i missing here? and maybe someone can help me with the way to join with zend way?

best regards

ron

**derrida** · 03-13-2010 07:40 AM

hi

saw this way and implemented it to my situation:

Code:

$select = $this->select(); 
        $select->setIntegrityCheck(false); 
        $select->from('posts', 'posts.*'); 
        $select->joinLeft('categories', 'posts.category_id = categories.id');

the setIntegrityCheck is crucial, set it to false.

**lion21** · 03-15-2010 05:02 PM

Originally Posted by derrida

hi

saw this way and implemented it to my situation:

Code:

$select = $this->select(); 
        $select->setIntegrityCheck(false); 
        $select->from('posts', 'posts.*'); 
        $select->joinLeft('categories', 'posts.category_id = categories.id');

the setIntegrityCheck is crucial, set it to false.

wat this "setIntegrityCheck" function is for ??

Thread: problem with an sql JOIN

LinkBack

Thread Tools

Search Thread

Display

problem with an sql JOIN

manage to fixed it

Similar Threads

Zend_DB join

Problem with left join

Zend_db_table and join

(another) zend_paginator + join problem

join,left join and right join in zend_db_table

Posting Permissions