<?php ob_start(); ?>
	<!DOCTYPE html>
	<html>
	<?php include "layouts/db_connect.php"; ?>
		<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		
		<!-- Meta, title, CSS, favicons, etc. -->
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta http-equiv="X-UA-Compatible" content="chrome=1">
		<meta name="viewport" content="width=device-width, initial-scale=1">

		<title>INFOSSEL SOFT SOLUTIONS </title>
		</head><body>
		<?php
// PDO connect *********
$ff = NULL;
$sql = mysqli_query($conn, "SELECT * FROM pending where mfin='MAATHOOR FINANCE' && rdate='$ff' order by hpl ASC");
while($row=mysqli_fetch_array($sql)) {
	$idd = $row['id'];
	$mfin22 = $row['mfin'];
	$hpl = $row['hpl'];
	$sql5 = mysqli_query($conn, "select * from customerdetails where hpl='$hpl' && mfin='$mfin22'");
	$row5 = mysqli_fetch_array($sql5);
	$eno  = $row5['eno'];
	$cno  = $row5['cno'];
	$bname  = $row5['bname'];
	$color  = $row5['color'];
	$hpamt  = $row5['hpamount'];
	$lat  = $row5['lat'];
	$lang  = $row5['lang'];
	$uimg  = $row5['uimg'];
	$img  = $row5['img'];
	$gi1  = $row5['g1'];
	$bi1  = $row5['b1'];
	$profession  = $row5['profession'];
	$rdate  = $row5['rdate'];
	$remarks  = $row5['remarks'];
	$cobname  = $row5['cobname'];
	$update = mysqli_query($conn, "update pending set eno='$eno',cno='$cno',bname='$bname',color='$color',hpamt='$hpamt',lat='$lat'
,lang='$lang',uimg='$uimg',img='$img',gi1='$gi1',bi1='$bi1',profession='$profession',rdate='$rdate',remarks='$remarks',cobname='$cobname' where id='$idd'");
}

?> </body></html>