ช่วยดูโค๊ด การ insert ข้อมูล หลาย record ให้หน่อยค่ะ

if($option == 'cancel'){
	 $str = " BILL_DATE = '".$bill_date."' ";  
	 
      $sqlc=mysql_query("select * from INVOICE where INVOICE_BATCH_NUMBER ='".$bill_no."' and SUPPLIER_CODE ='".$_SESSION["SUPPLIER_CODE"]."' AND TYPE = 'R' and".$str."")or die(mysql_error());
	  
      $temple=mysql_fetch_array($sqlc);
              $invoiceid = $temple['INVOICE_ID'];
		      $invoiceno = $temple['INVOICE_NO'];
		      $po_no = $temple['PO_NO'];
		      $inv_date = $temple['INV_DATE'];
		      $inv_amount = $temple['INV_AMOUNT'];
		      $payment_amount = $temple['PAYMENT_AMOUNT'];
		      $tax_amount = $temple['TAX_AMOUNT'];
		      $inv_tax = $temple['INV_TAX'];
		      $with_tax = $temple['WITHHOLDINGTAX'];
			  
   
   $strin = mysql_query("insert into invoicecancle ( `INVOICE_ID`,`INVOICE_NO`,`PO_NO`,`INV_DATE`,`TAX_AMOUNT`,`INV_AMOUNT`,`SUPPLIER_CODE`,`INV_TAX`,`WITHHOLDINGTAX`,`PAYMENT_AMOUNT`,`INVOICE_BATCH_NUMBER`,`BILL_DATE`) values ('$invoiceid','$invoiceno','$po_no','$inv_date','$tax_amount','$inv_amount','$supplier','$inv_tax','$with_tax','$payment_amount','$bill_no','$bill_duedate')");  
 // $str = " BILL_DATE = '".$bill_date."' ";  
 }