MySQL Forums
Forum List  »  Perl

Getting the Output for 'do' query.
Posted by: Sara Samsara
Date: June 30, 2007 08:19AM

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'.
Running query in phpMyAdmin prints the '2864' sum of all mins.
How I am supposed to print the same results here in script.

Thanks,
Sara.



Edited 1 time(s). Last edit at 06/30/2007 08:22AM by Sara Samsara.

Options: Reply• Quote


Subject
Written By
Posted
Getting the Output for 'do' query.
June 30, 2007 08:19AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.