my $root =1;
my $counter = 1;
rebuild_tree($root);

sub rebuild_tree{
my $idy = shift;

my $result= $dbh->prepare("SELECT id FROM terms WHERE parent_id = ?");
my $left = $dbh->prepare("UPDATE terms SET left_id=? WHERE id = ?");
my $right= $dbh->prepare("UPDATE terms SET right_id=? WHERE id = ?");


$left->execute($ctr++,$idy);
$result->execute($idy);
  while (my $i = $result->fetchrow_hashref()) {
  rebuild_tree($i->{id});
  }
$right->execute($ctr++,$idy);

}#end of sub