zend db select table doesn't exist error

Question

So I'm trying to execute this query:

SELECT r.refID AS rID, avgrat FROM rcc r;

with Zend_Db_Select

So I have this code:

$sql = new Zend_Db_Select($db);
$sql->from(array("r" => "rcc"), array("rID" => "refID"), "avgrat");
$stmt = $db->query($sql);
$result = $stmt->fetchAll();

But then I get mysql db error which complains that Base table or view not found: 1146 table avgrat.rcc doesn't exist..

even though the table does indeed exist

what did I do wrong?

Try your sql in command line. Is it works?

Dinuka Thilanga
– Dinuka Thilanga

2011-11-18 06:21:35 +00:00
Commented Nov 18, 2011 at 6:21 — Dinuka Thilanga
– Dinuka Thilanga, Commented Nov 18, 2011 at 6:21

Yes Barry · Accepted Answer · 2011-11-18 07:23:54Z

2

The problem may be that you're passing avgrat as the third parameter to from(), which is actually for setting the $schema. So, unless your database is actually named avgrat then try:

$sql->from(array('r' => 'rcc'), array('rID' => 'refID', 'avgrat'));

edited Nov 18, 2011 at 7:23

answered Nov 18, 2011 at 7:06

Yes Barry

9,9465 gold badges54 silver badges77 bronze badges

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

Comments

Dinuka Thilanga · Accepted Answer · 2011-11-18 06:17:14Z

0

Is this table exist in the database?

Try this

$sql = new Zend_Db_Select($db);
$sql->from(array("r" => "rcc"), array("refID AS rID"), "avgrat");
$stmt = $db->query($sql);
$result = $stmt->fetchAll()

answered Nov 18, 2011 at 6:17

Dinuka Thilanga

4,35010 gold badges59 silver badges94 bronze badges

Collectives™ on Stack Overflow

zend db select table doesn't exist error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related