Untitled

<html>
<?php

require "../auth.php";

include_once("../dbconnect.php");

$result = mysql_query(" SELECT * FROM clients ORDER BY client_id DESC  ");

?>
<head>
    <meta charset="utf-8">
    <title>Новая техника</title>
</head>
<body>
<form method="post" action="addtech.php">

Наименование:<br>
<input required type="text" name="category" required><br>
Производитель:<br>
<input required type="text" name="prod" required><br>
Модель:<br>
<input required type="text" name="model" required><br>
Клиент:<br>

<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'] ?></option>
    <?php } ?>
</select><br>
<input type="submit" name="add" value="Добавить">
</form>
<a href="tech.php">Вернуться назад</a>
<?php

if(isset($_POST['add'])){

  $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(" INSERT INTO tech(category,prod,model,client_id)
              VALUES ('$category','$prod','$model','$client_id') ");
  mysql_close();
  header("Location: tech.php");

}

?>

</body>
</html>