ช่วยดูโค๊ดหน่อยค่ะว่าผิดอะไรค่ะ โค๊ดนี้มันไม่ยอมเพิ่มข้อมูลให้ค่ะ มันแจ้งว่า ชื่อเครื่องนี้ได้ทำการแจ้งซ่อมไปแล้ว...

 <?
include "dbconjob.php";	
	 
$date_ = date("Ymd");
$ff = mysql_query("select * from repair ") or die(mysql_error());
$num = mysql_num_rows($ff);
if($num > 0)
{
$lastid_sql = mysql_query("SELECT idrepair FROM repair  WHERE  idrepair LIKE '".$date_."%' ORDER BY idrepair DESC") or die(mysql_error());
$num_cus = mysql_num_rows($lastid_sql);
 
if($num_cus > 0)
{
$last_id = mysql_fetch_row($lastid_sql);
$lastid = $last_id[0];
$str = explode("E",$lastid);
$add_date = $str[0];
$customer_id = $str[1];
$i = $num_cus+1;
$ticket_number=$date_."E".substr("00000".$i,-4,4);
}
else
{
 $i=1;
$ticket_number=$date_."E".substr("00000".$i,-4,4);
}
} else {
 $i=1;

 $ticket_number=$date_."E".substr("00000".$i,-4,4);
}
 
if($_POST["submit"]!="")
{
	$error = 0;
	$computername=$_POST['computername'];
	$repair=$_POST['repair'];
	$cause=$_POST['cause'];
	$namesent=$_POST['namesent'];
	$dept_id=$_POST['dept_id'];
	$datesent=$_POST['datesent'];
	$hardware_oth=$_POST['hardware_oth'];
	$location=$_POST['location'];
	$tel=$_POST['tel'];
	if($computername=="" or $repair=="" or $namesent=="" or $datesent=="") 
			{
				echo "<center><font color='red'>";
				echo "กรุณากรอกข้อมูลที่มี * ให้ครบ<br>";
				echo "<a href='newjob.php'>กลับไปแจ้งซ่อม</a><br>";
				$error = 1;
			}	
					if ($error==0)
					{	
					$check="Select * from repair where computername='$computername' and  status_id=1 or status_id=2";
					$checkqury= mysql_query($check) or die(mysql_error());
 				    $numrows = mysql_num_rows($checkqury); 
					
					if ($numrows ==0)
					{
						for($j=0;$j<count($_POST["hardware"]);$j++)
						{
							if(trim($_POST["hardware"][$j]) != "") 
								{
								 $sql ="INSERT INTO 		repair(idrepair,idcom,computername,repair,cause,hardware,hardware_oth,namesent,dep_id,datesent,location,tel,status_id)";
 								 $sql .="  VALUES ('$ticket_number',NULL,'$computername','$repair','$cause','".$_POST["hardware"][$j]."','$hardware_oth','$namesent','$dept_id','$datesent','$location','$tel','1')"; 
// echo "$sql";
 								 $objQuery = mysql_query($sql) or die(mysql_error());
 								 $str="INSERT INTO  history (com_name,idrepair)";
 								 $str.= " VALUES ('$computername','$ticket_number')";
								 $query=  mysql_query($str) or die(mysql_error());		 	
								echo "ระบบได้ทำการแจ้งซ่อมแล้วค่ะ";   
								echo "<a href='viewjob.php'>ดูที่แจ้ง</a></b></center>"; 
								}				
						 }
						
					}
					else
					{
					    echo "<center><font color='red'>ชื่อเครื่องนี้ได้ทำการแจ้งซ่อมแล้ว</font>";
						echo "<center><font color='red'><a href='viewjob.php'>ไปดูที่แจ้งซ่อม</a></font>";
										
 					 }
 				 } 
}
?>