Simple PHP Update, isn't working

programming
1

Cant figure out why this isn’t working. Any help please


<?php

include("db_connect.php");

$id= $_POST['id_update'];
$hostname= $_POST['hostname_update'];
$mac= $_POST['mac_update'];
$type= $_POST['type_update'];
$ad_joined= $_POST['ad_joined_update'];


$result = mysql_query("UPDATE devices SET hostname='" . $_POST['hostname'] . "', ip='" . $_POST['ip'] . "', mac='" . $_POST['mac'] . "', type='" . $_POST['type'] . "', ad_joined='" . $_POST['ad_joined'] . "' WHERE id='" . $_POST['id'] . "'");
$row = mysql_query($result);


echo "Record updated! </br>";
echo "Redirecting to inventory...";


?>

The form has the above set, upon submitting form which uses the above to process, it gives no error but seems to remove details and not add.