Debug recursion

[kioto <kiotoster@xxxxxxxxx>]

Hi all i have found a bug in my db class when i use the recursion.
I try to use the adjacency list model to develop a three menu but
when i call the function in recursive way i loose data because
the value returned from the fetch seem to be empty.
I have db table like this:
table catalog
ID | Name_Category | Subcategory
1 node category 0
2 1_sub_category 1
3 2_sub_category 1
4 another_node 0
5 another_node 0


I have this db class code:
http://phpfi.com/229087
And i create an instance of such class with this code.
http://phpfi.com/229088
My problem is that i take only the fist main category, the subcategory of
this node and later the function esc and doesn't print the other main
category.
I have try to use the native php mysql function and the code work
then the problem i suppose is in my class.

Procedural way with native functions

unction buildThree($parent)
{
	$sql = "SELECT id, name_category FROM category WHERE subcategory =
{$parent}";
	$rs = mysql_query($sql) or die(mysql_error());
	
	if ($rs) {
		while (list($id, $nome) = mysql_fetch_array($rs)) {
			$sql2 = "SELECT id FROM category WHERE subcategory = {$id}";
			$rs2 = mysql_query($sql2) or die(mysql_errno());
			
			$total = mysql_num_rows($rs2);
			
			if ($total) {
				echo'<li> # '.$nome.' '."\n\r".'<ul>'."\n\r";
				buildThree($id);
				echo"</ul>"."\n\r"."</li>"."\n\r";
			} else {
				echo'<li> ?m=product&amp;cat='.$id.' '.$nome.' </li>'."\n\r";
			}
		}	
	}
}


echo '<ul>';
buildThree(0);
echo '</ul>';



echo '<ul>';
buildThree(0);
echo '</ul>';
-- 
View this message in context: http://www.nabble.com/Debug-recursion-tf3632803.html#a10143940
Sent from the PHP - General mailing list archive at Nabble.com.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php