Zend Framework Db Select Join table help

Question

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.

What's the actual error text?

stan
– stan

2009-08-19 20:39:58 +00:00
Commented Aug 19, 2009 at 20:39 — stan
– stan, Commented Aug 19, 2009 at 20:39

polygone · Accepted Answer · 2010-04-22 20:01:07Z

10

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

answered Apr 22, 2010 at 20:01

polygone

4074 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Elzo Valugi Over a year ago

Here is the rationale. zend-framework-community.634137.n4.nabble.com/…

Kid · Accepted Answer · 2010-06-22 15:39:37Z

5

You could also type fewer characters....

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

Good luck!

answered Jun 22, 2010 at 15:39

Kid

511 silver badge2 bronze badges

1 Comment

Azizur Rahman Over a year ago

Thanks for this. This was a great help in solving problem with same column names in joined tables.

Bill Karwin · Accepted Answer · 2009-08-19 20:39:24Z

0

Here's how I'd write it:

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

answered Aug 19, 2009 at 20:39

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Comments

Kropek · Accepted Answer · 2010-09-26 20:38:45Z

0

Other example:

select n.content, n.date, u.mail 
from notes n, users u
where n.id_us=u.id and reminder=current_date

$query = $this->select()
    ->from(array('n'=>'notes'), 
      array('content', 'date'))
    ->join(array('u'=>'users'), 'n.id_us=u.id and n.reminder=current_date',
      array('mail'))
    ->setIntegrityCheck(false);
return $this->fetchAll($query);

That's work fine :)

answered Sep 26, 2010 at 20:38

Kropek

1

Collectives™ on Stack Overflow

Zend Framework Db Select Join table help

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related