my $count = 0;
  while ( my $row = $sth->fetchrow_arrayref() )
  {
      $count++;
      # do something with $row..
  }
  print( "There were $count row(s)\n" );