{
//自動的に新しい見積番号を作成される
$sql5="select substr(MNo,1,8)from MitumoriUser";
$sql6="select substr(MNo,9,3)from MitumoriUser";
$result5 = mysql_query($sql5,$dbh);
$record_num1=mysql_num_rows($result5);
//echo mysql_result($result5,$record_num1-1);
$result6 = mysql_query($sql6,$dbh);
$record_num2=mysql_num_rows($result6);
//echo mysql_result($result6,$record_num2-1);
$max1=mysql_result($result5,$record_num1-1);
$max2=mysql_result($result6,$record_num2-1);
//echo $max;
$_POST['mno1']=$max1+1;
$mno1=$_POST['mno1'];
//echo $mno1;
$_POST['mno2']=$max2;
$mno2=$_POST['mno2'];
//echo $mno2;
$sql7="select concat('$mno1','$mno2')from MitumoriUser";
$result7 = mysql_query($sql7,$dbh);
$record_num3=mysql_num_rows($result7);
//echo mysql_result($result7,$record_num3-1);
$mno=mysql_result($result7,$record_num3-1);
echo $mno;
$sql1="INSERT INTO MitumoriUser(MNo,MDate,EffectiveDay,Remarks,Remarks1,Remarks2,StartDate,EndDate,ReceiveCondition,PayCondition,MitumoriSituation,CashUndecided,Round, CashTaxOut,CashTaxIn,CashStock)
values ('$mno','$mdate','$effectiveday','$remarks','$remarks1','$remarks2','$startdate','$enddate','$receivecondition','$paycondition','完了','1','1','1','1','1')";
$result1 = mysql_query($sql1,$dbh);
} |