|
|
Posted by Marc on 09/28/26 11:43
Stefan Rybacki schreef:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Marc schrieb:
>
>>Hi there,
>>
>
>
> Hi
>
>
>>I've got this function and I want to fill a new query with the output of
>>this function. But I only get one value out of the array. How can I pass
>>the output of this function into a new query?
>>
>>tnx marc
>>
>
>
> ok lets have a look of what you're trying to achieve.
>
>
>>// $parent is the parent of the children we want to see
>>// $level is increased when we go deeper into the tree,
>>// used to display a nice indented tree
>>function display_children($parent, $level) {
>> // retrieve all children of $parent
>> $result_btnt = mysql_query('SELECT nt FROM btnt '.
>> 'WHERE bt="'.$parent.'";');
>>
>> // display each child
>> while ($row = mysql_fetch_array($result_btnt)) {
>> // indent and display the title of this child
>>
>> return $row['nt'];
>
>
> return *exits* the current function
>
>
>>
>> // call this function again to display this
>> // child's children
>> display_children($row['nt'], $level+1);
>
>
>
> I guess what you want is to move return $row['nt'] over here and you
> might don't want to miss to add a check for the current level before you
> call display_children (just in case you don't want to display the entire
> tree).
>
>
> Btw. your database design is not the best for what you're doing, because
> you're querying your database very often to retrieve the tree until a
> specific level.
> You can do better doing for example one of the following steps:
> - - for example if you know your max tree depth, create just one query
> with as much as joins as levels, and retrieve the tree at once (could be
> slow on big level depths)
> - - use a different database design like nestes sets
>
> Regards
> Stefan
>
>
>> }
>>
>>}
>
>
Hi Stefan,
I don't know what the max tree depth is, because for every bt/nt query
it is different.
Do you know how I can 'export' the full array out of this function to a
query?
Because when I move the $row['nt'] to the point you suggested. I only
get one result instead of the whole array..
Regards
Marc
Navigation:
[Reply to this message]
|