my $sth = "UPDATE users SET name = ? WHERE id = ?";
@bind_values = ($cgi->param('test'), $id);

$dbh->do($sth, undef, @bind_values) or die DBI::errstr;