Getting Output for 'do' Query.

2007-06-30 Thread sara.samsara
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 p

Re: Getting Output for 'do' Query.

2007-06-30 Thread Ricky Zhou
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > 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. 1