my $sth = $dbh->prepare('insert into tblfilm (name, price) values (?,?)'; $sth->execute($FilmName, $Price); #Update: I forgot, 'do' also accepts placeholder arguments like this.. $dbh->do('insert into tblfilm (name, price) values (?,?)', undef, $FilmName, $Price);