|
|
Posted by Stefan Rybacki on 06/15/65 11:43
-----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
>
> }
>
> }
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (MingW32)
iD8DBQFEKJjhyeCLzp/JKjARAvT0AJwLCsgCA4nBYE7YKiJMKho6ks8zLwCdHoJP
Sr3epvhiYxqYy8wLce8b+1A=
=7evJ
-----END PGP SIGNATURE-----
Navigation:
[Reply to this message]
|