mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$root = 1;
function display_tree($root) {
   // retrieve the left and right value of the $root node

   $result = mysql_query('SELECT lft, rgt FROM tree '.
                          'WHERE name="'.$root.'";');
   $row = mysql_fetch_array($result);

   // start with an empty $right stack
   $right = array();

   // now, retrieve all descendants of the $root node
   $result = mysql_query('SELECT COUNT(*), upline, name, lft, rgt FROM tree '.
                          'WHERE lft BETWEEN '.$row['lft'].' AND '.
                          $row['rgt'].' ORDER BY lft ASC;');

   // display each row
   while ($row = mysql_fetch_array($result)) {
      $counts = "".$row['COUNT(*)']."";
       // only check stack if there is one
       if (count($right)>0) {
           // check if we should remove a node from the stack
           while ($right[count($right)-1]<$row['rgt']) {
               array_pop($right);
           }
       }

       // display indented node name
       echo str_repeat('  ',count($right)).$row['name']."\n";

       // add this node to the stack
       $right[] = $row['rgt'];
   }
}

echo "".$row['name']." $counts ";

this is may be because of Query u used..!!

$result = mysql_query('SELECT COUNT(*), upline, name, lft, rgt FROM tree '.
'WHERE lft BETWEEN '.$row['lft'].' AND '.
$row['rgt'].' ORDER BY lft ASC;');

count return 1 result..

delete count(*) from query and use mysql_num_rows($result) for row count

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.