zend-framework output Zend_Db_Table's select() statement generated query

Question

hi all, i want to output the query generated by Zend_Db_Table's select() statement for testing porposes but i dont know how.

Answer 1

It's actually really easy. The select object implements a toString method.

$select = $table->select()->....
echo $select; //prints SQL

Or

$sql = $select->__toString();