recursive function calling by reference

[Stephanie Le Gall]

Hello,
I'm using a recursive function to get an array of ID from a database passing
the array by reference.

I need this structure for the function because the database structure is
like a tree and there is no limit of level.

Here is the code :

__________________________________________________ __
function remplir_tableau($id, &$arrayOfAllElem)
{
$arrayOfAllElem[] = $id;
$req_ksup = mysql_query("select kinf_ksup,nume_kard,soci_kard
from kardex_superieur
left join kardex on id_kard=kinf_ksup
where ksup_ksup='$id' ");

while ($row = mysql_fetch_array($req_ksup, MYSQL_NUM))
{
remplir_tableau($row[0], &$arrayOfAllElem);
}
}
remplir_tableau($id_kard, $TabKard);
__________________________________________________ ___


but if I don't change the php.ini file allow_call_time_pass_reference to
true I have a message :

Warning: Call-time pass-by-reference has been deprecated - argument passed
by value; If you would like to pass it by reference, modify the declaration
of [runtime function name](). If you would like to enable call-time
pass-by-reference, you can set allow_call_time_pass_reference to true in
your INI file. However, future versions may not support this any longer.
I have the error message but the function seems to work anyway !
Is there any way else to do that ? ... or to not have the message ?
Thanks a lot for helping !

Stéphanie

[Janwillem Borleffs]

Stephanie Le Gall wrote:

I have the error message but the function seems to work anyway !
Is there any way else to do that ? ... or to not have the message ?

Change the recursive call to:

function remplir_tableau($id, &$arrayOfAllElem)
{
.....
remplir_tableau($row[0], $arrayOfAllElem);
}
}

JW

[Stephanie Le Gall]

Thanks a lot !!!!

I've juste seen my error ... And I feel terrible sending a post like that
!!!

Stéphanie
"Janwillem Borleffs" <[e-mail]> a écrit dans le message de
news:44**************@jwscripts.com...

Stephanie Le Gall wrote:

I have the error message but the function seems to work anyway !
Is there any way else to do that ? ... or to not have the message ?

Change the recursive call to:

function remplir_tableau($id, &$arrayOfAllElem)
{
.....
remplir_tableau($row[0], $arrayOfAllElem);
}
}

JW

[Chung Leong]

Stephanie Le Gall wrote:

Hello,
I'm using a recursive function to get an array of ID from a database passing
the array by reference.

I need this structure for the function because the database structure is
like a tree and there is no limit of level.

Just a suggestion. Retrieving a tree from the database in the manner
you described can be expensive, since every nodes would trigger a
separate query. Usually what I do in a situation like this is to add a
column holding the id to the root of the tree, so that I could retrieve
all the rows at once. Then I use a recursive function to build the
tree.