Code crushers

[thoand]

How can I build a tree out of this

MySQL Table:

| pid | page | nparent |
------+---------------+------------+
| 1 | Pagename | 0 |
| 2 | Pagename | 0 |
| 3 | Pagename | 2 |
| 4 | Pagename | 2 |
| 5 | Pagename | 1 |
| 6 | Pagename | 4 |
| 7 | Pagename | 4 |

...

pid colum is auto_increment and nparent colum is the pid value.
I know I kan builde a tree out of this but having difficulties to put it to code 😕

thanks in advance ,
Thomas A.

[sijis]

i don't have the exact code, but i'll give you an idea that may/may not be helpful.

$query_db  = select from table;

$count_pid = count($query_db)

// looping through the main pid categories.
for ($i = 1; $i <= $count_pid; $i++) {
  echo "Parent"; 
   // check to see if there is an sub of parent.
   if(nparent == $i){
    //make new query based on current value of $i in loop
    $query_db2 = select from table where nparent = '$i';
       // loop through all possible sub of parent matches.
       while($row = mysql_fetch_array($query_db2)){
         echo "sub of parent";
        }
   }
}

enjoy 🙂

[thoand]

I'll give it a try 🆒

[milind24]

you need to try recursivley create tree ,

Try this it will Help you , make your own customising this

function Make_Tree($id,$myroot,$tree)
{
	/*
	  Your Database connection goes here
	*/
	$query = "SELECT * FROM TABLENAME Where  nparent=$id ORDER BY page";
	$dresult=mysql_query($query);
	$myroot++;
	while($drow=mysql_fetch_array($dresult))
	{
		$mysapce="";
		for($i=0;$i < $myroot;$i++)
			 $mysapce .="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
		$tree .= $mysapce.$drow[page]."<br>";
		$tree = Make_Tree($dcid,$myroot,$tree); // recursively calling function
	}
	return $tree;
}
$id=0;
$myroot="";
$tree="";
print Make_Tree($id,$myroot,$tree);