Getting Output for 'do' Query.
| Newsgroups | perl.beginners.cgi |
|---|---|
| Message-ID | <000c01c7bb28$13a89610$5b3d87cb@mts1bbdcac7a71> |
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.