Nested_Sets addSQL question

From: Date: Mon, 17 May 2004 18:51:26 +0000
Subject: Nested_Sets addSQL question
Groups: php.general 
Request: Send a blank email to php-general+get-186420@lists.php.net to get a copy of this message
Hi all, I'm having a problem with the Nested Sets package, I want to use the addSQL function to retreive extra information from a different table, now my query works, however new columns aren't returned :( I hope anyone knows how to retreive them? Here is my (test) SQL statement: $addSQL = array( 'cols' => 'category.creator', 'join' => 'LEFT JOIN category ON pw1_category.name=category.categoryname_en', 'where' => 'pw1_category.name=category.categoryname_en', 'append' => 'GROUP by category.categoryname_en'); $categorys = $nestedSet->getChildren($_GET['id'],true,true,false,$addSQL); All columns i have specified in the $factory $params work perfectly but i can't add my new category.creator field because it will then automaticly add the first tablename in front of it :( Any help is appriciated.. Greetings Tim

« previous php.general (#186420) next »