Untitled

<?php
  require "../auth.php";
?>
<html>
<head>
    <meta charset="utf-8">
    <title>Измененеие данных</title>
</head>
<body>
<?php
include_once("../dbconnect.php");

$id = $_GET["id"];

$query = "SELECT * FROM services WHERE service_id='$id'";
$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

?>

<form method="post" action="editservice.php?id=<?php echo $id; ?>">

Название детали:<br>
<input required type="text" name="service_name" value="<?php echo $row['service_name']; ?>"><br>

Цена:<br>
<input required type="text" name="service_cost" value="<?php echo $row['service_cost']; ?>"><br>

Использованные детали(<?php echo $row['detail_id']; ?>):<br>
<?php
$result = mysql_query(" SELECT * FROM details ");
?>
<select name="detail_id" required>
    <option></option>
    <?php while($row = mysql_fetch_assoc($result)){ ?>
    <option value="<?php echo $row['detail_id'] ?>" ><?php echo $row['name'] ?>(<?php echo $row['detail_id'] ?>)</option>
    <?php } ?>
</select><br>

<input type="submit" name="save" value="Сохранить">
<?php


        if(isset($_POST['save'])){
        $service_name = strip_tags(trim($_POST['service_name']));
        $service_cost = strip_tags(trim($_POST['service_cost']));
        $detail_id = strip_tags(trim($_POST['detail_id']));

        mysql_query(" UPDATE services SET service_name='$service_name', service_cost='$service_cost', detail_id='$detail_id' WHERE service_id='$id' ");

        mysql_close();

        header("Location: services.php");
}
?>
<a href="service.php">Вернуться назад</a>
</form>
</body>
</html>