Does this php prepare code look ok. Im an trying to update a record in a DataBase and i feel this may be the issue

Does this php prepare code look ok. Im an trying to update a record in a
DataBase and i feel this may be the issue

Here is prepare update statement and I think i Have the Variable types out
of whack, not sure.
// if everything is fine, update the record in the database
if ($stmt =
$mysqli->prepare("UPDATE
`Calibration_and_Inspection_Register`
SET `item_type` = ?,
`location` = ?,
`date_last_test` = ?,
`serial_number` = ?,
`date_next_test` = ?,
`comments` = ?
WHERE `id`=?"))
{
$stmt->bind_param("issdsds",`$id`,
`$item_type`, `$location`,
`$date_last_test`,
`$serial_number`,
`$date_next_test`,
`$comments`);
$stmt->execute();
$stmt->close();
}