my @hours; # so we have a permanent variable with our data
while (my @row = $sth->fetchrow_array) { push(@hours, $_) for @row }
my %byhour;
foreach my $hours (@hours)
{
$hours =~ /\s(\d\d)/;
my $knownhour = $1;
##########
# enter hours into our hash for counting
##########
if (exists $byhour{$knownhour})
{
my $hourcount = $byhour{$knownhour};
$hourcount++;
$byhour{$knownhour} = $hourcount;
}
else
{
$byhour{$knownhour} = 1;
}
}
foreach (keys %byhour) { print "$_ had $byhour{$_}
"; }
####
10 had 2
15 had 21
14 had 4
####
0 had 0
1 had 0
2 had 0
3 had 0
.. skip..
14 had 4
15 had 23
16 had 0
.. skip..