Recursivity in Database

[Anon]

Hi,

Is it possible to use recursivity with a query result?
Bellow is the code (some):

<?php

require("class.php");

//conect is the constructor function in the class
$instance = new conect();

function mapa($COD=1){

if ($instance->query("SOME SELECT)")){

while ($array = ibase_fetch_row($instance->result)){
mapa($array[1]);
}
echo("$array[1]");
}
}

mapa();
?>

[tomhath]

Seems like it should work, although you are changing a global variable ($instance->result) every time you recurse, so the result of this code will probably not be what you want.