my $query = qq|SELECT SUM(MINS) FROM files WHERE USER='$user'|; my $do = $dbh->do($query); print "$do";
Where MINS is integar, Now when I print $do it obviously prints only '1', marking return of the query. Running query in phpMyAdmin prints the '2864' sum of all mins. How I am supposed to print the same results here in script instead of '1' only. Thanks, Sara.
