อัพเดทข้อมูลที่ตารางในฐานข้อมูลไม่ได้คะ ต้องการความช่วยเหลือมากๆคะ

<?
		   include("connect.php");
	
		   mysql_connect('localhost','root','1234');
		   mysql_select_db('charter_db') or die('ไม่พบฐานข้อมูล');
		   $setthai= mysql_query("SET NAMES 'utf8' ");
		   $sqlsave_pawn="select * from save_pawn";
		   $datasave_pawn=mysql_query($sqlsave_pawn) or die('เขียน sql ผิด');
		   $count = mysql_num_rows($datasave_pawn);

		 
if($_GET[action]=="update")
{
$sqlsearch="select * from save_pawn where id_pro='$_GET[sid]' ";
$datasearch=mysql_query($sqlsearch)or die("sql ผิด");
$fieldstd=mysql_fetch_array($datasearch);
$id_pro=$fieldstd[id_pro];
$id_ptype=$fieldstd[id_ptype];
$id_proS=$fieldstd[id_proS]; 
$date_exportSell=$fieldstd[date_exportSell];
$imgfront_sp=$fieldstd[imgfront_sp];
$imgback_sp=$fieldstd[imgback_sp]; 
$imgside_sp=$fieldstd[imgside_sp];
$priceexport_sp=$fieldstd[priceexport_sp];
$comment_sp=$fieldstd[comment_sp];
}		 
$sqlsearch="select * from product where id_pro='$_GET[sid]' ";
$datasearch=mysql_query($sqlsearch)or die("sql ผิด");
$fieldpro=mysql_fetch_array($datasearch);
$name_pro=$fieldpro[name_pro];
$generation_pro=$fieldpro[generation_pro];
$devie_pro=$fieldpro[devie_pro];

echo "<form action=\"sale-saveDeatail.php\" method=\"post\">";
echo "<table width=\"560\" border = \"0\" align=\"center\" bgcolor=\"#FFCCCC\">";

echo "<tr >";
echo "<td align=\"right\" bgcolor=\"#FF99FF\">รหัสสินค้า :</td>";
echo "<td>";
echo "<input type=\"text\" name=\"id_pro\" value=\"$id_pro\">";
echo "</td>";
echo "</tr>";
echo "<tr>";

echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">ประเภทสินค้า :</td>";
echo "<td>";

$sqlbranch="select * from product_type";
$databranch=mysql_query($sqlbranch);
echo "<select name=\"id_ptype\" bgcolor=\"#FF99FF\">";
while($fieldbranch=mysql_fetch_array($databranch))
{
$mid=$fieldbranch[id_ptype];
$mname=$fieldbranch[name_ptype];
if($id_ptype==$mid)
{
echo "<option value=\"$mid\" selected> $mname </option>";
}
else
{
echo "<option value=\"$mid\"> $mname </option>";
}
}
echo "</select>";
echo "</td>";
echo "</tr>";

echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">ชื่อสินค้า :</td>";
echo "<td>";
echo "<input type=\"text\" size=\"30\"name=\"name_pro\" value=\"$name_pro\" disabled=\"disabled\" readonly=\"readnly\">";
echo "</td>";
echo "</tr>";

echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">รุ่น :</td>";
echo "<td>";
echo "<input type=\"text\" size=\"30\"name=\"generation_pro\" value=\"$generation_pro\" disabled=\"disabled\" readonly=\"readnly\">";
echo "</td>";
echo "</tr>";
?>

<?
echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">สถานะสินค้า :</td>";
echo "<td>";

$sqlbranch="select * from product_status";
$databranch=mysql_query($sqlbranch);
echo "<select name=\"id_proS\">";
while($fieldbranch=mysql_fetch_array($databranch))
{
$mid=$fieldbranch[id_proS];
$mname=$fieldbranch[name_proS];
if($id_proS==$mid)
{
echo "<option value=\"$mid\" selected> $mname </option>";
}
else
{
echo "<option value=\"$mid\"> $mname </option>";
}
}
echo "</select>";
echo "</td>";
echo "</tr>";


 ?>
			   <tr>
		         <td align="right"bgcolor="#FF99FF">วันที่ขายสินค้า</td>
		          <td><div align="left"><input type="date" name="date_sale" value="<?=date('Y-m-d');?>"/></div></td>
				 </tr>

				<tr>
		          <td align="right"bgcolor="#FF99FF">เลขที่บัตรประจำตัวประชาชน</td>
		          <td><div align="left"><input type="text" name="idCard_sale"/></div></td>
	            </tr>
                	
				<tr>
		          <td align="right"bgcolor="#FF99FF">ชื่อ-สกุลผู้ซื้อ</td>
		          <td><div align="left"><input type="text" name="nameSur_sale"/></div></td>
	            </tr>	
				<tr>
		          <td align="right"bgcolor="#FF99FF">ที่อยู่ผู้ซื้อ</td>
		          <td><div align="left">
		            <label for="textarea"></label>
		            <textarea name="address_sale" id="textarea" cols="30" rows="5"></textarea>
		          </div></td>
	            </tr>

				<tr>
		          <td align="right"bgcolor="#FF99FF">เบอร์โทรศัพท์</td>
		          <td><div align="left" ><input type="text" name="tel_sale"/></div></td>
	            </tr>

<?
echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">ราคาขายหน้าเว็บ :</td>";
echo "<td>";
echo "<input type=\"text\" name=\"priceexport_sp\" value=\"$priceexport_sp\" disabled=\"disabled\" readonly=\"readonly\">";

echo "</td>";
echo "</tr>";
?>
				<tr>
		          <td align="right"bgcolor="#FF99FF">ราคาขายออก</td>
		          <td><div align="left"><input type="number" name="exportSale_sale"/></div></td>
	            </tr>
<?
echo "</td>";
echo "</tr>";

  ?>
<?
echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\">หมายเหตุ :</td>";
echo "<td>";
echo "<input type=\"text\" name=\"comment_sp\" value=\"$comment_sp\">";
echo "</td>";
echo "</tr>";

echo "<tr>";
echo "<td align=\"right\"bgcolor=\"#FF99FF\"> </td>";
echo "<td>";
echo "<input type=\"submit\" value=\"บันทึก\">";
echo "<input type=\"reset\" value=\"ยกเลิก\">";
echo"<a href=\"sale-receipt.php?sid=$id_pro&action=save\"><input type=\"button\" value=\"พิมพ์ใบเสร็จ\"</a>";
echo"<a href=\"sale-save.php\"><input type=\"button\" value=\"เลือกรายการสินค้า\"</a>";

 ?>
<?
echo "<input type=\"hidden\" name=\"action\" value=\"save\">";
echo "<input type=\"hidden\" name=\"old_stdid\" value=\"$id_pro\">";

echo "</table>";
echo "</form>";


	  if($_POST[action]=="save")
			{
				$sqlsearch="select* from sale where id_pro='$_POST[id_pro]' ";
				$datasearch=mysql_query($sqlsearch) or die("sql ผิด");
				$count=mysql_num_rows($datasearch);
				if($count>0)
				{
					echo "รหัส $_POST[id_pro]  ซ้ำ กรุณากรอกใหม่";
				}
				else
				{

				$sqlsave="insert into sale
				(id_pro,
				id_proS,
				id_ptype,
				date_sale,
				idCard_sale,
				nameSur_sale,
				address_sale,
				tel_sale,
				exportSale_sale) 
				values
				($_POST[id_pro],
				$_POST[id_proS],
				$_POST[id_ptype],
			   '$_POST[date_sale]',
				'$_POST[idCard_sale]',
				'$_POST[nameSur_sale]',
				'$_POST[address_sale]',
				'$_POST[tel_sale]',
				$_POST[exportSale_sale])";
			
			//echo "$sqlsave";
			mysql_query("update save_pawn set id_proS = $id_proS WHERE id_pro = '$_POST[id_pro]'  "); // ตรงนี้อ่ะคะที่ยังไม่ได้
			mysql_query($sqlsave)or die(mysql_error());
			echo "บันทึกข้อมูลเรียบร้อยเเล้วคะ";
			}
			}
									
			
					

			
			
		
			
			  								
?>