PHP Stock ช่วยด้วยคับเรื่องการลบตัวเลข การยิงลดจำนวนสต๊อกคับ

<?
	
include ("conne.php");
      $sql="select  * from c_stock WHERE`c_stock`.`barcode_item` ='$barcode_item2' "; 
	$dbquery = @mysql_db_query(koolsport_stock,$sql);
$result = mysql_fetch_array($dbquery);
$barcode_item = $result[barcode_item];
$number = $result[number];
$number2 = $number + $number1;
 

if($barcode_item=="$barcode_item2"){

$sql_edit = "update c_stock set number = '$number2' WHERE `c_stock`.`barcode_item` ='$barcode_item2'";
$db_query=@mysql_db_query(koolsport_stock,$sql_edit) or die ("$sql_edit");
}
   else {      $sql = "insert into c_stock(barcode_item,number) VALUES('$barcode_item2', '$number1')";
         $db_query=@mysql_db_query(koolsport_stock,$sql) or die ("$sql");
}



?>
  
  
  
  
  
</p>
<p align="center"><a href="update_zone.php">บันทึกในโซน ZONE</a></p>
<p align="center"><a href="update_zone1.php">บันทึกนอกคลัง</a></p>
<table width="598" border="0" align="center">
<tr>
      <td width="164" bgcolor="#00CCFF"><div align="center">barcode</div></td>
      <td width="298" bgcolor="#00CCFF"><div align="center">ชื้อ</div></td>
      <td width="114" bgcolor="#00CCFF"><div align="center">จำนวนสต๊อก</div></td>
  </tr>
<?
   $sql1="select  * from item LEFT JOIN c_stock ON (item.barcode_item = c_stock.barcode_item)Where number > 0 ";
$Qtotal = mysql_query($sql1);
	 
     $qr =@mysql_db_query(koolsport_stock,$sql1) or die("error $sql1");
	 $row =@mysql_num_rows($qr);
$i=0;
while ($i<$row){
$rs=mysql_fetch_array($qr);
$barcode_item = $rs[barcode_item];
$name_item = $rs[name_item];
$number = $rs[number];
?>

<tr>
      <td bgcolor="#CCCCCC"><div align="center"><? echo $barcode_item;?></div></td>
      <td bgcolor="#CCCCCC"><div align="center"><? echo $name_item; ?></div></td>
      <td bgcolor="#CCCCCC"><div align="center"><? echo $number;?></div></td>
    </tr>
	<?
$i++;
}
?>
</table>