Nested_Sets addSQL question
| From: | T.H. Boonstra | 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