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 tech WHERE tech_id='$id'";
$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

?>

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

Наименование:<br>
<input required type="text" name="category" value="<?php echo $row['category']; ?>"><br>

Производитель:<br>
<input required type="text" name="prod" value="<?php echo $row['prod']; ?>"><br>

Модель:<br>
<input required type="text" name="model" value="<?php echo $row['model']; ?>"><br>
Клиент(<?php echo $row['client_id']; ?>):<br>
<?php
$result = mysql_query(" SELECT * FROM clients ORDER BY client_id DESC  ");
?>
<select name="client_id" required>
    <option></option>
    <?php while($row = mysql_fetch_assoc($result)){ ?>
    <option value="<?php echo $row['client_id'] ?>" ><?php echo $row['client_name'] ?>(<?php echo $row['client_id']; ?>)</option>
    <?php } ?>
</select><br>
<input type="submit" name="save" value="Сохранить">
<?php

    if(isset($_POST['save'])){
    $category = strip_tags(trim($_POST['category']));
    $prod = strip_tags(trim($_POST['prod']));
    $model = strip_tags(trim($_POST['model']));
    $client_id = strip_tags(trim($_POST['client_id']));

    mysql_query(" UPDATE tech SET category='$category', prod='$prod', model='$model' client_id='$client_id' WHERE tech_id='$id' ");

    mysql_close();

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