ตรวจสอบข้อมูลซ้ำด้วย Ajax โดย Textbox ที่รับค่าเป็นแบบ array(ดึงข้อมูลจาก Database)

<?php
while($objResult = mysql_fetch_array($objQuery))
{
?>	
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
$(document).ready(function(){

	$("#txtserial,#txtassetNumber").change(function(){

			$("#sserial").empty(); 
			$("#sassetNumber").empty();

			$.ajax({ 
				url: "returnCustomer1.php" ,
				type: "POST",
				data: 'sserial=' +$("#txtserial").val()+'&assetNumber='+$("#txtassetNumber").val()
			})
			.success(function(result) { 

					var obj = jQuery.parseJSON(result);

					if(obj != '')
					{
						  $.each(obj, function(key, inval) {

								   if($("#txtserial").val() == inval["serial"])
								  {
									   $("#sserial").html(" <font color='red'>Serial นี้มีอยู่แล้ว</font>");
								  }

								   if($("#txtassetNumber").val() == inval["assetNumber"])
								  {
									   $("#sassetNumber").html(" <font color='red'>Asset Numberนี้มีอยู่แล้ว</font>");
								  }

						  });
					}

			});

		});
	});
</script>
	
<?php	
	$resultequipment[] = $objResult["equipment"];
?>
<?php
	echo "<input type='hidden' name='articles[]' value='" .$objResult["equipment"]. "'>";
	$count++
	
?>
  <tr>
  	<td bgcolor="#CCCCCC" height="5" bgcolor="#FFFFFF" align="center"><font color="#333399" size="2"><?php echo $count;?></font></td>
    <td bgcolor="#CCCCCC" height="60" bgcolor="#FFFFFF" align="center"><font color="#333399" size="2"><?php echo $objResult["equipment"];?></font></td>
<?php
	echo "<td bgcolor='#CCCCCC'><input type='text' size='10' name='txtbrand[]' value=''></td>";
	echo "<td bgcolor='#CCCCCC'><input type='text' name='txtmodel[]' value=''></td>";
	
	echo "<td bgcolor='#CCCCCC'><input type='text' size='10' id='txtserial' name='txtserial[]' value=''> 
	<span id='sserial'></span></td>"; //เช็ค Serial
	
	echo "<td bgcolor='#CCCCCC'><input type='text' size='10' id='txtassetNumber' name='txtassetNumber[]' value=''>
	<span id='sassetNumber'></span></td>"; //เช็ค Asset Number
	
	echo "<td bgcolor='#CCCCCC'><input type='text' name='txtremark[]' value=''></td>";
?>
   </tr>
<?php
}
?>

<?php
	$objConnect = mysql_connect("localhost","root","1234") or die(mysql_error());
	$objDB = mysql_select_db("asset_db");
	$strSQL = "SELECT * FROM vehicle_tb WHERE (1 AND serial = '".$_POST["sserial"]."' OR assetNumber = '".$_POST["assetNumber"]."') and assetNumber !='' ";
	$objQuery = mysql_query($strSQL) or die (mysql_error());
	$intNumField = mysql_num_fields($objQuery);
	$resultArray = array();
	while($obResult = mysql_fetch_array($objQuery))
	{
		$arrCol = array();
		for($i=0;$i<$intNumField;$i++)
		{
			$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
		}
		array_push($resultArray,$arrCol);
	}
	
	mysql_close($objConnect);
	
	echo json_encode($resultArray);
?>