sub find_items {
 $idd = shift;

 $sth23 = $dbh->prepare("SELECT id FROM category WHERE parent = '$idd'");
 $sth23->execute or die $dbh->errstr;
 while ($idg = $sth23->fetchrow_array) {
  $itemn = find_items($idg);
  my $adf += $itemn;
 }

 $sth3 = $dbh->prepare("SELECT category FROM items WHERE category = '$idd'");
 $sth3->execute or die $dbh->errstr;
 my $rvf = $sth3->rows;
 my $bdf += $rvf;

 $cdf = $adf + $bdf;
 return($cdf);

 }