$tovar = (int)$_POST["tovar"];
$Art = (int)$_POST["Art"];
$user = $_POST["user"];
$kolvo = (int)$_POST["kolvo"];
$strSQL = "UPDATE `Tovar` SET  `$user` = '$user'-'$kolvo' WHERE `id`= '$tovar' OR `Art`= '$Art'";

echo "<form name='update2' action='update.php' method='POST'>
      <select name='user'>
	    <option value=''>-- Я --</option>;
		<option value='Almaz'>-- Алмаз --</option>;
		<option value='Linar'>-- Линар --</option>;
		</select>
	 <br/>
	  <select name='update2'>
	    <option value=''>---</option>;
	  <option value='0'>Все</option>";
    
$result =  mysql_query ("SELECT * FROM Tovar") 
                or die ("<b>Query failed:</b> " . mysql_error());
 
while ($row = mysql_fetch_array($result)){
 
echo "<option value=' ".$row['id']." '>".$row['name']."</option>";
}
if ($_SERVER['REQUEST_METHOD'] == "POST"){
    $op = $_POST['name']; 
    mysql_query ("SELECT * FROM Tovar where id=".$op);
  
}
echo "</select>"; 
echo"<br/>";
echo "<label><input type='text' name='kolvo' /> В количестве</label><br/>
<label><input type='text' name='Art' /> Артикул</label><br/>
<input type='submit' name='Показать' value='Обновить'/><br/></form>";
	
?>

<?php
include ("bd.php");

$tovar = (int)$_POST["tovar"];
$Art = (int)$_POST["Art"];
$user = $_POST["user"];
$kolvo = (int)$_POST["kolvo"];
$strSQL = "UPDATE `Tovar` SET  `$user` = '$user'-'$kolvo' WHERE `id`= '$tovar' OR `Art`= '$Art'";

	  mysql_query($strSQL) or die (mysql_error());
	mysql_close();



?>