# Now retrieve data from the table. my $sth = $dbh->prepare("SELECT * FROM Success_Matrix"); $sth->execute(); while (my $ref = $sth->fetchrow_hashref()) { print "Totals by day: id = $ref->{'id'}, Total_Number_Failures = $ref->{'Total_Number_Failures'}\n"; } $sth->finish(); #### Totals by day: id = , Total_Number_Failures = 47 Totals by day: id = , Total_Number_Failures = 47 Totals by day: id = , Total_Number_Failures = 52 Totals by day: id = , Total_Number_Failures = 42 Totals by day: id = , Total_Number_Failures = 39 Totals by day: id = , Total_Number_Failures = 68 Totals by day: id = , Total_Number_Failures = 48 Totals by day: id = , Total_Number_Failures = 39 Totals by day: id = , Total_Number_Failures = 38 Totals by day: id = , Total_Number_Failures = 51 Totals by day: id = , Total_Number_Failures = 39 Totals by day: id = , Total_Number_Failures = 36 Totals by day: id = , Total_Number_Failures = 44 Totals by day: id = , Total_Number_Failures = 52 Totals by day: id = , Total_Number_Failures = 45 Totals by day: id = , Total_Number_Failures = 79