Category hierarchy problem............
Please support our PHP advertiser: Free Online Load Test - How many visitors can your web site handle?
![]() |
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,
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,
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; } }
Last edited by peter_budo : Dec 2nd, 2008 at 7:15 pm. Reason: Please, either use [code] or [code=php] (or other langiage as necessary). DO NOT USE [code language=php]
Hii...
What it seems from your code is, you are storing the value after mysql_fetch_array in an array without an id..
So try this code..
Try this code... The system im using right now doesnt have PHP installed.. so cant check it here.. Hope this helps you.. If any problem comes, then tell me the error..
What it seems from your code is, you are storing the value after mysql_fetch_array in an array without an id..
So try this code..
//mysql connection
$objcatId = new catId();
$rsId[] = explode(",",$objcatId->prod_view(22));
print_r($rsId);
class catId{
static $idvalues="";
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))
{
if(self::$idvalues=="")
{
self::$idvalues=$row['id'];
}
else
{
self::$idvalues.=",".$row['id'];
}
$this->prod_view($row['id']);
}
}
return self::$idvalues;
}
}Try this code... The system im using right now doesnt have PHP installed.. so cant check it here.. Hope this helps you.. If any problem comes, then tell me the error..
•
•
Posts: 72
Reputation:
Solved Threads: 3
Chris, Director, Chrisranjana.com
Web developers and software programmers.
Web developers and software programmers.
![]() |
Similar Threads
Other Threads in the PHP Forum
- 0x8004010F error in all Offline Address Books from Exchange 2000 server (Windows NT / 2000 / XP / 2003)
Other Threads in the PHP Forum
- Previous Thread: search from database
- Next Thread: PHP Gaming basics
•
•
•
•
Views: 339 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)





Linear Mode