Hi!
1.I Run Programs add data ,add master data save after Continue add detail data (use Below inline add) ,
[save] item Disappear,just see [Cancel] item ,Why? Not directly Detailed data can not be added, go in to detail not have this problem
use phprunner ver 6.1(build 12662)and database is mysql 5.0.51a
2.This Programs is 2 Table,master table is buy_m ,detail table is buy_d ,
Programs inline add detail buy_d put this code in the add page:before record added,
add one row data is ok ,but add two row data show error message:Duplicate entry '1107L-1' for key 1
Why the ser_no data Should be 2
Thanks
the code :
global $conn;
$strSQL="select max(ser_no) as ser_no from buy_d where sno='".$_Session[$sno."_masterkey1"]."' ";
$rs = db_query($strSQL,$conn);
$data=db_fetch_array($rs);
if($data['ser_no']!='' or $data['ser_no']!=null)
{
$ser_no=($data['ser_no']+1);
$values['ser_no']=sprintf("%s",$ser_no);
}else{
$values['ser_no']=sprintf("%s",1);
}
db_exec($strSQL,$conn);