my $query = "UPDATE items SET price=? WHERE itemref=?";
$sth = $dbh->prepare ( $query );
$sth->execute ($price, $itemref);
$sth->finish ();