-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
Greg Jetter wrote:
> my $query = "insert into tablename
> (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2,
> $somthing3);
>
>
> # insert stuff in the db
>
> $dbh->do($query) or die "$DBI::errstr";
To prevent SQL injection, etc. It's strongly recommended that you use
place
