query("SELECT * FROM discharge WHERE hospital_id='$rs[entered_by]' AND date(admissiondate) BETWEEN '$from_date' AND '$to_date' AND (typevisit='OPD' OR typevisit='Opd_Emergency' OR typevisit='OPD_Routine' )");
while($RowDischarge = mysqli_fetch_array($discharge))
{
$a++;
$addaspatient =$con->query("SELECT * FROM addaspatient WHERE prescriptionid='$RowDischarge[prescriptionid]'");
while($RowPatient = mysqli_fetch_array($addaspatient))
{
$sqlpatient = $con->query("SELECT * FROM patient_invace WHERE prescriptionid='$RowPatient[prescriptionid]' AND discription='Consultant_fees' AND grand_total!='grand_total'");
while($rsp = mysqli_fetch_array($sqlpatient))
{
$sql9 =$con->query("SELECT * FROM site_users WHERE userno='$RowPatient[Admitted_Under]'");
while($re9 = mysqli_fetch_array($sql9))
{
$sql4 =$con->query("SELECT * FROM patient WHERE patientid='$RowPatient[patientid]'");
while($rp = mysqli_fetch_array($sql4))
{
echo "
$a
Name : $re9[name]
$rsp[grand_total]
UHID :$rp[patientid]
Patient Name $rp[patientname]