";
$c = 0;
while ($rowj = mysqli_fetch_array($resultfU1))
{
$c++;
$sql = "SELECT placeroute.Route,CENT_QFL_NO,PLACE_NM,MST_CENT.ROUTE FROM placeroute,MST_CENT,MST_CENT_QFL,PLACE WHERE FK_CENT_ID = PK_CENT_ID AND FK_PLACE_ID = PK_PLACE_ID AND FK_QFL_ID = 3 AND placeroute.Place = PLACE_NM AND CENT_QFL_NO = '".$rowj['CENT']."'";
$result = mysqli_query($_SESSION['Linker'],$sql);
if (!$result)
{
die("Failed ".$sql.mysqli_error($_SESSION['Linker']));
}
$row = mysqli_fetch_array($result);
//print_r($row);
echo $rowj['CENT']." ".$row['CENT_QFL_NO']." ".$row['Route']." ".$row['PLACE_NM']."
";
$FSQL = "UPDATE dispatched set route ='".$row['Route']."' WHERE BoxNumber = '".$rowj['BoxNumber']."'";
echo $FSQL."
";
$result2 = mysqli_query($_SESSION['Linker'],$FSQL);
if (!$result2)
{
die("Failed ".$FSQL.mysqli_error($_SESSION['Linker']));
}
}
echo $c."-Records ";
?>