Re: Array output from function into a new query
- From: Stefan Rybacki <stefan.rybacki@xxxxxxx>
- Date: Mon, 27 Mar 2006 21:01:05 -0500
-----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-----
.
- Follow-Ups:
- References:
- Array output from function into a new query
- From: Marc
- Array output from function into a new query
- Prev by Date: Re: multiple image upload / email script?
- Next by Date: Re: beginning PHP problem
- Previous by thread: Array output from function into a new query
- Next by thread: Re: Array output from function into a new query
- Index(es):
Relevant Pages
|
