Zend Framework Db Select Join table help

sql zend-framework select join zend-db
tester2001 picture tester2001 · Aug 13, 2009 · Viewed 22k times · Source

I have this query:


SELECT g.title, g.asin, g.platform_id, r.rank
        FROM games g
        INNER JOIN ranks r ON ( g.id = r.game_id )
        ORDER BY r.rank DESC
        LIMIT 5`

Now, this is my JOIN using Zend_Db_Select but it gives me array error


$query = $this->select();
        $query->from(array('g' => 'games'), array());
        $query->join(array('r' => 'ranks'), 'g.id = r.game_id', array('g.title', 'g.asin', 'g.platform_id', 'r.rank'));
        $query->order('r.rank DESC');
        $query->limit($top);
        $resultRows = $this->fetchAll($query);
        return $resultRows;

Anyone know what I could be doing wrong? I want to get all the columns in 'games' to show and the 'rank' column in the ranks table.

Answer

polygone picture polygone · Apr 22, 2010

I am going to assume you've solved this, but it would be nice to leave the answer for others.

Add this below the instantiation of the select object.

$query->setIntegrityCheck(false);

Related questions

Emulate MySQL LIMIT clause in Microsoft SQL Server 2000

When I worked on the Zend Framework's database component, we tried to abstract the functionality of the LIMIT clause supported by MySQL, PostgreSQL, and SQLite. That is, creating a query could be done this way: $select = $db->select(); $select-&…

Read More
How update a database table record in Zend?

I am using select like this and it is fetching record successfully: $table = new Bugs(); $select = $table->select(); $select->where('bug_status = ?', 'NEW'); $rows = $table->fetchAll($select); But Now I want to update same record. For …

Read More
Writing a subquery using Zend DB

I am having some problems turning the SQL below into a Zend Db query. $select = ' SELECT s.id, i.id as instance_id, i.reference, i.name, i.sic_code, i.start_date FROM sles s JOIN sle_instances …

Read More