zend db query fetching undesirable columns

Question

so I have this code:

$db = new Zend_Db_Adapter_Pdo_Mysql($params);
$sql = $db->select()->from(array("r" => "recc"), array("r_id" => "refID"))->joinLeft(array("c" => "comment"), "r.refID = c.refID");
$results = $db->fetchAll($sql);
print_r($results);

which is supposed to translate to this query:

SELECT refID AS r_id FROM recc r LEFT JOIN comment c ON r.refID = c.refID

which is supposed to only return a single column r_id and it indeed returned that single column when executed with mysql query browser

but then when you execute it with db select and print_r the results, in addition to r_id it also returned a whole bunch of fields in table comment which are populated with empty data...

did I do something wrong? how do I get the thing to only return the single column as planned...

Yes Barry · Accepted Answer · 2011-11-04 05:23:02Z

2

I think it's the joinLeft(). You may need to pass an empty array() as a third parameter.

$sql = $db->select()
    ->from(array("r" => "recc"), array("r_id" => "refID"))
    ->joinLeft(array("c" => "comment"), "r.refID = c.refID", array());

answered Nov 4, 2011 at 5:23

Yes Barry

9,9465 gold badges54 silver badges77 bronze badges

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

Comments

coolguy · Accepted Answer · 2011-11-04 05:30:07Z

0

    Try 
    print_r($results->toArray()); //Pure array format of result
    array('')  //    If you dont want columns from a joining table you pass as the last parameter to the join    
 array('*') //IF you want all the fields

edited Nov 4, 2011 at 5:30

answered Nov 4, 2011 at 5:19

coolguy

7,9549 gold badges48 silver badges72 bronze badges

Collectives™ on Stack Overflow

zend db query fetching undesirable columns

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