Hello.
I have the following problem:
I want to use Zend_Db_Table_Select to join two tables, but I always get this error message:
Code:
Warning: Select query cannot join with another table in /home/.../Zend/Db/Table/Select.php on line 191
Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty' in /home/.../Zend/Db/Statement/Pdo.php:238
Stack trace: #0 /home/.../Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/.../Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/.../Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 /home/.../Zend/Db/Table/Abstract.php(1184): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 /home/.../Zend/Db/Table/Abstract.php(1039): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#5 /var/www/.../test/test.php(26): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#6 {main} thrown in /home/.../Zend/Db/Statement/Pdo.php on line 238
This is the code I'm using:
PHP Code:
$table = new Members();
$select = $table->select();
$select->join('groups', 'members.group_id=groups.id', 'groups.name');
$rows = $table->fetchAll($select);
My database has the following tables:
members: id,group_id,[...]
groups: id,name
Members.php:
PHP Code:
class Members extends Zend_Db_Table_Abstract {
protected $_name = 'members';
}
and Groups.php
PHP Code:
class Groups extends Zend_Db_Table_Abstract {
protected $_name = 'groups';
}
I hope I gave all relevant information; if not, please tell me!
I hope someone can help me.
Cheers,
Florian