<form class="forma" action="/pantones/form.php" method="post" name="forma"> 
			<th style="width: 110px;" class="forma" for="pantone">Пантон №</th><br/> 
			<th style="width: 110px;" class="forma" for="count">Количество</th><br/>
			<th style="width: 110px;" class="forma" for="client">Заказчик</th><br/>
			<th style="width: 110px;" class="forma" for="order">Заказ</th><br/>
		<tr>
			<td class="forma"><input style="width: 100px;" type="text" name="pantone" ></td>
			<td class="forma"><input style="width: 100px;" type="text" name="count" ></td>
			<td class="forma"><input style="width: 100px;" type="text" name="client" ></td>
			<td class="forma"><input style="width: 100px;" type="text" name="order" ></td>
		</tr>	
		<tr><td style="border: 0px;"><input id="submit" type="submit" value="Отправить данные"></form>

<?php require 'connect.php'; ?>
<?php header('Location: /pantones.html'); ?>
<?php


	$pantone = $_POST['pantone'];
	$count = $_POST['count'];
	$last_change= $_POST['last_change'];
	$client = $_POST['client'];
	$order = $_POST['order'];
	$count_f = str_replace(",",".",$count);
	
	//результат нажатия на кнопку отправить
	$nQ = mysql_query("SELECT * FROM pantones WHERE pantone ='$pantone'"); 
		if(mysql_num_rows($nQ)) { 
			mysql_query("UPDATE `pantones` SET `last_change` = `count`, `count` = '$count_f', `client` = CONCAT(`client`, ' ' , '$client'), `order` =CONCAT(`order`, ' ' , '$order') WHERE `pantone` = '$pantone';") or die(mysql_error()); 
			//echo "Информация изменена <a href=/index.php>OK</a>"; 
			} 
		else { 
			mysql_query("INSERT INTO `pantones` (`pantone`, `count`, `last_change`, `client`, `order`)  VALUES ('$pantone', '$count_f', '$last_change', '$client', '$order');") or die(mysql_error()); 
			//echo "Информация занесена в базу данных <a href=/index.php>OK</a> ";
			}; 
		
			mysql_query ('SET @n = 0');
			$query = mysql_query ('UPDATE `pantones` SET id = (@n := @n + 1)');
		mysql_close();
?>

<?php require 'connect.php'; 

$bd = mysql_connect ("localhost","root","");
mysql_select_db("laminpack",$bd);

$result = mysql_query("SELECT * FROM `pantones`",$bd);
 
echo "<table style='margin-left: 15px;'>";
echo "<tr><th>№</th><th>Пантон №</th><th>Количество, кг</th><th>Изменение</th><th>Заказчик</th><th>Заказ</th></tr>";
while ($row=mysql_fetch_array($result)){
$pole1=$row[0];
$pole2=$row[1];
$pole3=$row[2];
$pole4=$row[2]-$row[3];
$pole5=$row[4];
$pole6=$row[5];

echo "<tr><td>$pole1</td><td>$pole2</td><td>$pole3</td><td>$pole4</td><td>$pole5</td><td>$pole6</td></tr>";
}
echo "</table>"; 
?>