$sth_max_score->execute(); # no loop here: my @max_score = $sth_max_score->fetchrow_array(); # now $max_score[0] holds your desired value #### $sth->execute(); $sth->bind_columns(\my $max); $sth->fetch; # $max holds the value here