DaniWeb IT Discussion Community - View Single Post - Category hierarchy problem............

Category hierarchy problem............

Dec 2nd, 2008

Hello friends,

I've a category table, the structure is:

category{
id int(11) autoincrement,
name varchar(255),
parentid int(11);
}

Now a node can have multiple child nodes and grand child nodes. now if I want to get all childnodes and grandchild nodes of a node id what should i do ???????

I've written a recursive function but this is not working properly,

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
//mysql connection
 
 
$objcatId = new catId();
$rsId[] = $objcatId->prod_view(22);
print_r($rsId);
 
class catId{
 
	var $id;
 
	function prod_view($id){
 
	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);
 
	if($num > 0){
 
		while($row = mysql_fetch_array($sql)){
 
			$idArray[] = $row['id'];
 
			$this->prod_view($row['id']);
		}		
 
	}	
		//print_r($idArray);
		return $idArray;
	}	
 
}
//mysql connection


$objcatId = new catId();
$rsId[] = $objcatId->prod_view(22);
print_r($rsId);

class catId{
	
	var $id;
		
	function prod_view($id){
		
	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);
		
	if($num > 0){
		
		while($row = mysql_fetch_array($sql)){
			
			$idArray[] = $row['id'];
			
			$this->prod_view($row['id']);
		}		
		
	}	
		//print_r($idArray);
		return $idArray;
	}	

}

Last edited by peter_budo; Dec 2nd, 2008 at 8:15 pm. Reason: Please, either use [code] or [code=php] (or other langiage as necessary). DO NOT USE [code language=php]