Does that syntax work for updates? Try this:

my $sth = $dbh->prepare("
    UPDATE products set 
    pname=?, unit=?, qty=?, cost=?
    WHERE id = ?
");
$sth->execute($pname, $unit, $qty, $cost, $id);
[download]

(Use a comma instead of AND)