<?php
include '../_connect.php';
$D1 = $_POST['D1'];
$M1 = $_POST['M1'];
$Y1 = $_POST['Y1'];
$DAYS = $Y1."-".$M1."-".$D1;
$strSQL = "INSERT INTO CONFIG.dbo.REG_BILLDATATRANSPORT";
$strSQL .="(REG_NO, REG_DATE, REG_CROP, REG_BANDNAME, REG_PSERIAL_NO,
            REG_USERBREG, REG_BREG, REG_BILLBREG, REG_BILLBREGTRANSPORT ,REG_USERTRANSPORT1,
            REG_BILLUSER1, REG_USERTRANSPORT2, REG_BILLUSER2, REG_PROVINCE, REG_DIFFERENCE,
            REG_NOTE) ";
// $strSQL .="(REG_PSERIAL_NO) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["REG_NO"]."','$DAYS','".$_POST["REG_CROP"]."','".$_POST["REG_BANDNAME"]."','".$_POST["REG_PSERIAL_NO"]."',
            '".$_POST["REG_USERBREG"]."','".$_POST["REG_BREG"]."','".$_POST["a1"]."','".$_POST["sss1"]."','".$_POST["REG_USERTRANSPORT1"]."',
            '".$_POST["a2"]."','".$_POST["REG_USERTRANSPORT2"]."','".$_POST["a3"]."','".$_POST["tsp_transport"]."','',
            '".$_POST["REG_NOTE"]."')";
$result = $conn->query($strSQL);
echo $strSQL;
if($result)
{ }
else
{ }
?>
