recursive in table

[maheswaran]

Hi all,

I have problem in getting data from database using recursive function...

I have the table called "master_info"

project id | Child_of | Project_name
=====================================
1 | 0 | Project 1

2 | 0 | Project 2

3 | 1 | Sub project of 1

I want project list in drop down list like

Project 1
- - Sub project of 1
Project 2
Project 3

For this i did some recursive function

 function projectrecursive($pid)
 { 
    if($pid!="")
    {
        $qry4prj="select Project_id,Child_of,Project_name from master_info where Project_id='$pid'";
    }
    else
    {
        $qry4prj="select Project_id,Child_of,Project_name from master_info"; //Step 2
    }
    $Res4prj=mysql_query($qry4prj);
     $cnt4prj=mysql_num_rows($Res4prj);
 
     if($cnt4prj>0)
    {
                                                                                                         while(list($prid,$childid,$tasksum)=mysql_fetch_Array($Res4prj))
          {    
          if($childid=="0")
          {
             $projectlist.='<option value='.$pr_id.'>'.$tasksum.'</option>';    //Step 3                         
           }
               else
            {
            $projectlist.=projectrecursive($prid); //Step 4 - here after getting recursive i should get out from this recursive loop but am getting continue
 
            }
        }
    }
 
    return $projectlist;
 }
 
$projectcall=projectrecursive(); // Step 1
 

Step 1:

I called recursive function with out any project id.

Step 2:

Check the condition , if project id is null then it will get the data with out any condition. Its for getting the project id and name which they have not child_of i.e who are not any child project for another projects

Step 3

Listing the projects which they not child for other projects [i.e child_of = 0]

Step 4

if any projects is child of to any one of project [i.e child_of = have sum value] then i called recursive function to get the child & parent project name

In this step i getting project id as 3 also child_of is 1 , and program should go to out of loop but problem is i got condition true [i.e child_of = have sum value] so i getting value 3 as projekct id and 1 as child_of value and its getting continue loop....

How i solve it......

[Markus]

Is that the code you are using?

[maheswaran]

yes, i tried with this... Also same table and fields i used

[Markus]

Please stick this at the very top of your PHP file.

error_reporting(-1);

[maheswaran]

Hi all,

Thanks, finally i got the answer. i paste the code here to may any one can use this for their recursive function

This below code will give the output of:

Project 1
------ Project 2 (Sub Project of 1)
------ Project 3 (Sub Project of 1)
------- Project 4 (Sub Project of 3)
Project 5
Project 6
------ Project 7 (Sub Project of 6)

<?php
    $database    =    "dbname";
    $dusername    =    "root";
    $dpassword    =    "password";
    $hostname    =    "localhost";
 
    mysql_connect($hostname,$dusername,$dpassword);
    mysql_select_db($database);
 
 
     $qry4prj="select Project_id,Child_of,Task_summary from project_info where Child_of='0'";
     $Res4prj=mysql_query($qry4prj);
     $cnt4prj=mysql_num_rows($Res4prj);
 
 
        if($cnt4prj>0)
        {
             while(list($prid,$childid,$tasksum)=mysql_fetch_Array($Res4prj))
            {   
                     $projectlist.='<option value='.$prid.'>'.$tasksum.'</option>';
 
                    $projectlist.=rec($prid);
                    $space="";
 
 
            }
        }
         function rec($prid,$loopvalue)
        {//echo "hi--".$loopvalue."<br>";
            global $i,$space;
            $i=$loopvalue;
 
            //echo "<br>1-->".
            $qry4prj1="select Project_id,Child_of,Task_summary from project_info where Child_of='$prid'";
             $Res4prj1=mysql_query($qry4prj1);
            // echo " &nbsp;&nbsp;&nbsp; 2-->".
            $cnt4prje=mysql_num_rows($Res4prj1);
             if($cnt4prje>0)
             {
                 while(list($prid1,$childid1,$tasksum1)=mysql_fetch_Array($Res4prj1))
                 {
                     //echo "&nbsp;&nbsp;&nbsp; 3-->".$i."";
                     $i++;
                      for($j=0;$j<=$i;$j++)
                     {
                          //echo "&nbsp;&nbsp;&nbsp; 4 -->".$j."";
                          $space.="- ";
                     }
                      $projectlist.='<option value='.$prid1.'>'.$space.' '.$tasksum1.'</option>';
                      $loopval=$i;
                      $projectlist.=rec($prid1,$loopval);
                 }
 
             }
 
             return $projectlist;
        }
    echo "<table cellpadding='0' cellspacing='0' border='0' align='left' style='margin-left:100px;'>
          <tr>
                <td> Project List    </td>
          </tr>
          <tr>
                <td>
                <select name='projectlistp'>
                $projectlist
                </select>
                </td>
         </tr>
         </table>";
 
?>