$where1 is the string which is written to temporary table seperated by the <hr> tag and later the table is displayed. $where1 = nl2br(implode("<hr>",$where_saleO+$where_saleI));
Below is the image for the table row.There must be 4 entries of FTP in it but its showing only 3.I have checked the arrays to make sure.
I used inspect on the element,found this <hr< td=""></hr<>
Ok so Instead of getting the string from arrays now I have done this $where1 = "FTP<hr>FTP<hr>FTP<hr>FTP";
and
this is the query,
$sql2 = "insert into hold (site_code,store_name,ip_address,inbound_status,sale_miss,pay_miss,missing_in_sale,missing_in_pay) values ('$rss','$store_name','$ip','$add ','$missingfilesale','$missingfilepay','$where1','$where2')";
Still same problem, Only 3 FTPs are displayed
echo "<td>". $rrf['missing_in_sale'] ."</td>"; using for display
$sql2 = “insert into hold (site_code,store_name,ip_address,inbound_status,sale_miss,pay_miss,missing_in_sale,missing_in_pay) values (‘$rss’,‘$store_name’,‘$ip’,‘$add ‘,’$missingfilesale’,‘$missingfilepay’,‘$where1’,‘$where2’)”;
Table creation. $sql1 = "create temporary table hold (site_code varchar(50) not null,store_name varchar(50) not null,ip_address varchar(50) not null,inbound_status varchar(50) not null,sale_miss varchar(5000) not null,pay_miss varchar(5000) not null,missing_in_sale varchar(20) not null,missing_in_pay varchar(20) not null)";
Found The Problem.
missing_in_sale varchar(20) changed it to missing_in_sale varchar(1000). Now it Works.