recursive function

[prokrast]

So I'm trying to write a recursive function that goes through a mySQL database and prints out a bunch of things (it's basically a tree-style support system). Here's my code for the recursive function:

function printOut($myResult) {
while ($theRow = mysql_fetch_array($myResult,MYSQL_ASSOC)) {
print $theRow['content'] . "(".$theRow['id'].")<br>";
$theID = $theRow['id'];
$subResult = mysql_query("SELECT * FROM questionTree WHERE refID='$theID'",$db);
printOut($subResult);
}
}

It hits the top three items in the database, but it can't figure out any of the sub-items, I get this error:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/treeEditor.php for lines 6 & 9.

So I know that there's something I don't understand about how mySQL queries work . . . but I don't really know how to fix the problem. Any suggestions?

[nemonoman]

The error message tells you that MySQL has not yet processed the query.

The problem is this line:
$subResult = mysql_query("SELECT * FROM questionTree WHERE refID='$theID'",$db);

Specifically, $db is not defined. If $db is a global, you should add this line

global $db;

before running the query.
Alternatively, just try running the query without the second parameter, i.e.:

$subResult = mysql_query("SELECT * FROM questionTree WHERE refID='$theID'");

[laserlight]

It actually looks like it might be easier to code this iteratively than recursively.
What is the schema for the questionTree table, and what is the initial query?
Also, what exactly are you trying to do?