 <?php
header("Content-Type: application/vnd.ms-word");
header("Expires:0");
header("cache-control: must-revalidate, post-check=0, pre-check=0");
header("content-disposition: attachment, filename=print.doc");
?>

<?php
$con=mysql_connect("localhost", "root", "");
if(!$con)
{
  die('Could not connect:'.mysql_error());
}

$philres=$_POST["philres"];
$nonphil=$_POST["nonphil"];
$accom=$_POST["accomID"];
$year=$_POST["year"];
$month=$_POST["month"];
mysql_select_db("tcems",$con);
$search="SELECT * FROM tblnationality where Year='$_POST[year]' and Month='$_POST[month]' and Accom='$_POST[accomID]'";
$result = mysql_query($search);
$flag=0;
 while ($row=mysql_fetch_array($result))
{
  $bru=$bru+$row[3];
  $cam=$cam+$row[4];
$indo=$indo+$row[5];
$laos=$laos+$row[6];
$mal=$mal+$row[7];
$mya=$mya+$row[8];
$sing=$sing+$row[9];
$thai=$thai+$row[10];
$viet=$viet+$row[11];
$chi=$chi+$row[12];
$hong=$hong+$row[13];
$jap=$jap+$row[14];
$kor=$kor+$row[15];
$tai=$tai+$row[16];
$bang=$bang+$row[17];
$india=$india+$row[18];
$iran=$iran+$row[19];
$nep=$nep+$row[20];
$pak=$pak+$row[21];
$sri=$sri+$row[22];
$bahr=$bahr+$row[23];
$egy=$egy+$row[24];
$isra=$isra+$row[25];
$jor=$jor+$row[26];
$kuw=$kuw+$row[27];
$saudi=$saudi+$row[28];
$uae=$uae+$row[29];
$can=$can+$row[30];
$mex=$mex+$row[31];
$usa=$usa+$row[32];
$arg=$arg+$row[33];
$braz=$braz+$row[34];
$col=$col+$row[35];
$peru=$peru+$row[36];
$venez=$venez+$row[37];
$aus=$aus+$row[38];
$belg=$belg+$row[39];
$france=$france+$row[40];
$germ=$germ+$row[41];
$luxe=$luxe+$row[42];
$nether=$nether+$row[43];
$switz=$switz+$row[44];
$den=$den+$row[45];
$fin=$fin+$row[46];
$ire=$ire+$row[47];
$norw=$norw+$row[48];
$swe=$swe+$row[49];
$uk=$uk+$row[50];
$greece=$greece+$row[51];
$ita=$ita+$row[52];
$port=$port+$row[53];
$spa=$spa+$row[54];
$usm=$usm+$row[55];
$cis=$cis+$row[56];
$pol=$pol+$row[57];
$russ=$russ+$row[58];
$aust=$aust+$row[59];
$guam=$guam+$row[60];
$nauru=$nauru+$row[61];
$zea=$zea+$row[62];
$pap=$pap+$row[63];
$niger=$niger+$row[64];
$sa=$sa+$row[65];
$phil=$phil+$row[66];
$phil1=$phil1+$row[67];
  }
$sub1=$bru+$cam+$indo+$laos+$mal+$mya+$sing+$thai+$viet;
$sub2=$chi+$hong+$jap+$kor+$tai;
$sub3=$bang+$india+$iran+$nep+$pak+$sri;
$sub4=$bahr+$egy+$isra+$jor+$kuw+$saudi+$uae;
$sub5=$can+$mex+$usa;
$sub6=$arg+$braz+$col+$peru+$venez;
$sub7=$aus+$belg+$france+$germ+$luxe+$nether+$switz;
$sub8=$den+$fin+$ire+$norw+$swe+$uk;
$sub9=$greece+$ita+$port+$spa+$usm;
$sub10=$cis+$pol+$russ;
$sub11=$aust+$guam+$nauru+$zea+$pap;
$sub12=$niger+$sa;
$subphil=$phil+$phil1;
$subAll=$sub1+$sub2+$sub3+$sub4+$sub5+$sub6+$sub7+$sub8+$sub9+$sub10+$sub11+$sub12;
$grandTotal=$subAll+$subphil;
 mysql_close($con);

echo
"
<h1 align=center>REPORT ON THE REGIONAL DISTRIBUTION OF TRAVELERS</h1>
<table border='0' width='100%'>

    <tr>
        <td width='20%'>&nbsp</td>
        <td width='15%' align='right'>Month</td>
        <td width='15%'><input type='text' name='month' value=".$month."></td>
        <td width='15%' align='right'>Year</td>
        <td width='15%'><input type='text' name='year' style='width:99%' value=".$year.">
        </td>
     <td width='20%'>&nbsp</td>
    </tr>

 <tr>
    <td colspan=8>
        <table border='0' width='100%'>
            <tr>
                <td width='100%' colspan=3>Type of Accommodation</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td width='45%'>Hotel</td>
                <td width='45%'><input type='text' name='hotel' style='width:99%' value=".$_POST['hotel']."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td width='45%'>Pension Inn/Lodge</td>
                <td width='45%'><input type='text' name='pension' style='width:99%' value=".$_POST['pension']."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td width='45%'>Youth Hostel/Dormitory</td>
                <td width='45%'><input type='text' name='youth' style='width:99%' value=".$_POST['youth']."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td width='45%'>Apartel/Rented Homes/Apartment</td>
                <td width='45%'><input type='text' name='apartel' style='width:99%' value=".$_POST['apartel']."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td width='45%'>Others</td>
                <td width='45%'><input type='text' name='others' style='width:99%' value=".$_POST['others']."></td>
            </tr>

            <tr>
                <td width='30%'>AE ID Code (LGU Assigned)</td>
                <td width='30%'><input type='text' name='ae' style='width:99%' value=".$_POST['ae']."></td>
                <td width='*%'>&nbsp</td>
            </tr>

            <tr>
                <td width='30%'>City/Municipality</td>
                <td width='30%'><input type='text' value='Agoo' style='width:99%' readonly='readonly'></td>
                <td width='*%'>&nbsp</td>
            </tr>

            <tr>
                <td width='30%'>Province</td>
                <td width='30%'><input type='text' value='La Union' style='width:99%' readonly='readonly'></td>
                <td width='*%'>&nbsp</td>
            </tr>

            <tr>
            <td>&nbsp</td>
            </tr>
        </table>
       </td>
       </tr>
<tr>
    <td colspan=16>
    <table border='0' width='100%'>
     <tr>
     <td colspan=2 align=center>COUNTRY OF RESIDENCE</td>
      <td align=center>TOTAL</td>
      </tr>
     <tr>
                <td colspan=2>PHILIPPINE RESIDENTS</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>FILIPINO NATIONALITY</td>
                <td><input type='text' name='phil_nat' style='width:99%' value=".$phil."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>FOERIGN NATIONALITY</td>
                <td><input type='text' name='for_nat' style='width:99%' value=".$phil1."></td>
            </tr>

<!-- ASIA-->
            <tr>
                <td colspan=2>ASIA</td>
                <td>&nbsp</td>
            </tr>

<!-- ASEAN-->
            <tr>
                <td colspan=2>ASEAN</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>BRUNEI</td>
                <td><input type='text' name='brunei' style='width:99%' readonly='readonly' value=".$bru."></td>
            </tr>
       <tr>
                <td width='10%'>&nbsp</td>
                <td>CAMBODIA</td>
                <td><input type='text' name='cambodia' style='width:99%' readonly='readonly' value=".$cam."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>INDONESIA</td>
                <td><input type='text' name='indonesia' style='width:99%' readonly='readonly' value=".$indo."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>LAOS</td>
                <td><input type='text' name='laos' style='width:99%' readonly='readonly' value=".$laos."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>MALAYSIA</td>
                <td><input type='text' name='malaysia' style='width:99%' readonly='readonly' value=".$mal."></td>
            </tr>


            <tr>
                <td width='10%'>&nbsp</td>
                <td>MYANMAR</td>
                <td><input type='text' name='myanmar' style='width:99%' readonly='readonly' value=".$mya."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SINGAPORE</td>
                <td><input type='text' name='singapore' style='width:99%' readonly='readonly' value=".$sing."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>THAILAND</td>
                <td><input type='text' name='thailand' style='width:99%' readonly='readonly' value=".$thai."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>VIETNAM</td>
                <td><input type='text' name='vietnam' style='width:99%' readonly='readonly' value=".$viet."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='asean_st' style='width:99%' readonly='readonly' value=".$sub1."></td>
            </tr>

<!-- EAST ASIA-->
            <tr>
                <td colspan=2>EAST ASIA</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>CHINA</td>
                <td><input type='text' name='china' style='width:99%' readonly='readonly' value=".$chi."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>HONGKONG</td>
                <td><input type='text' name='hongkong' style='width:99%' readonly='readonly' value=".$hong."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>JAPAN</td>
                <td><input type='text' name='japan' style='width:99%' readonly='readonly' value=".$jap."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>KOREA</td>
                <td><input type='text' name='korea' style='width:99%' readonly='readonly' value=".$kor."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>TAIWAN</td>
                <td><input type='text' name='taiwan' style='width:99%' readonly='readonly' value=".$tai."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='eastasia_st' style='width:99%' readonly='readonly' value=".$sub2."></td>
            </tr>

<!-- SOUTH ASIA-->
            <tr>
                <td colspan=2>SOUTH ASIA</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>BANGLADESH</td>
                <td><input type='text' name='bangladesh' style='width:99%' readonly='readonly' value=".$bang."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>INDIA</td>
                <td><input type='text' name='india' style='width:99%' readonly='readonly' value=".$india."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>IRAN</td>
                <td><input type='text' name='iran' style='width:99%' readonly='readonly' value=".$iran."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NEPAL</td>
                <td><input type='text' name='nepal' style='width:99%' readonly='readonly' value=".$nep."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>PAKISTAN</td>
                <td><input type='text' name='pakistan' style='width:99%' readonly='readonly' value=".$pak."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SRI LANKA</td>
                <td><input type='text' name='srilanka' style='width:99%' readonly='readonly' value=".$sri."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='southasia_st' style='width:99%' readonly='readonly' value=".$sub3."></td>
            </tr>

<!-- MIDDLE EAST-->
            <tr>
                <td colspan=2>MIDDLE EAST</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>BAHRAIN</td>
                <td><input type='text' name='bahrain' style='width:99%' readonly='readonly' value=".$bahr."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>EGYPT</td>
                <td><input type='text' name='egypt' style='width:99%' readonly='readonly' value=".$egy."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>ISRAEL</td>
                <td><input type='text' name='israel' style='width:99%' readonly='readonly' value=".$isra."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>JORDAN</td>
                <td><input type='text' name='jordan' style='width:99%' readonly='readonly' value=".$jor."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>KUWAIT</td>
                <td><input type='text' name='kuwait' style='width:99%' readonly='readonly' value=".$kuw."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SAUDI ARABIA</td>
                <td><input type='text' name='saidiarabia' style='width:99%' readonly='readonly' value=".$saudi."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>UNITED ARAB EMERATES</td>
                <td><input type='text' name='uae' style='width:99%' readonly='readonly' value=".$uae."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='middleeast_st' style='width:99%' readonly='readonly' value=".$sub4."></td>
            </tr>

<!-- AMERICA-->
            <tr>
                <td colspan=2>AMERICA</td>
                <td>&nbsp</td>
            </tr>

<!-- NORTH AMERICA-->
            <tr>
                <td colspan=2>NORTH AMERICA</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>CANADA</td>
                <td><input type='text' name='canada' style='width:99%' readonly='readonly' value=".$can."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>MEXICO</td>
                <td><input type='text' name='mexico' style='width:99%' readonly='readonly' value=".$mex."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>USA</td>
                <td><input type='text' name='usa' style='width:99%' readonly='readonly' value=".$usa."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='northamerica_st' style='width:99%' readonly='readonly' value=".$sub5."></td>
            </tr>

<!-- SOUTH AMERICA-->
            <tr>
                <td colspan=2>SOUTH AMERICA</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>ARGENTINA</td>
                <td><input type='text' name='argentina' style='width:99%' readonly='readonly' value=".$arg."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>BRAZIL</td>
                <td><input type='text' name='brazil' style='width:99%' readonly='readonly' value=".$braz."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>COLOMBIA</td>
                <td><input type='text' name='colombia' style='width:99%' readonly='readonly' value=".$col."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>PERU</td>
                <td><input type='text' name='peru' style='width:99%' readonly='readonly' value=".$peru."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>VENEZUELA</td>
                <td><input type='text' name='venezuela' style='width:99%' readonly='readonly' value=".$venez."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='southamerica_st' style='width:99%' readonly='readonly' value=".$sub6."></td>
            </tr>

<!-- EUROPE-->
            <tr>
                <td colspan=2>EUROPE</td>
                <td>&nbsp</td>
            </tr>

<!-- WESTERN EUROPE-->
            <tr>
                <td colspan=2>WESTERN EUROPE</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>AUSTRIA</td>
                <td><input type='text' name='austri' style='width:99%' readonly='readonly' value=".$aust."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>BELGIUM</td>
                <td><input type='text' name='belgium' style='width:99%' readonly='readonly' value=".$belg."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>FRANCE</td>
                <td><input type='text' name='france' style='width:99%' readonly='readonly' value=".$france."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>GERMANY</td>
                <td><input type='text' name='germany' style='width:99%' readonly='readonly' value=".$germ."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>LUXEMBOURG</td>
                <td><input type='text' name='luxembourg' style='width:99%' readonly='readonly' value=".$luxe."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NETHERLANDS</td>
                <td><input type='text' name='netherlands' style='width:99%' readonly='readonly' value=".$nether."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SWITZERLAND</td>
                <td><input type='text' name='switzerland' style='width:99%' readonly='readonly' value=".$switz."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='westerneurope_st' style='width:99%' readonly='readonly' value=".$sub7."></td>
            </tr>

<!-- NORTHERN EUROPE-->
            <tr>
                <td colspan=2>NORTHERN EUROPE</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>DENMARK</td>
                <td><input type='text' name='denmark' style='width:99%' readonly='readonly' value=".$den."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>FINLAND</td>
                <td><input type='text' name='finland' style='width:99%' readonly='readonly' value=".$fin."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>IRELAND</td>
                <td><input type='text' name='ireland' style='width:99%' readonly='readonly' value=".$ire."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NORWAY</td>
                <td><input type='text' name='norway' style='width:99%' readonly='readonly' value=".$norw."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SWEDEN</td>
                <td><input type='text' name='sweden' style='width:99%' readonly='readonly' value=".$swe."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>UNITED KINGDOM</td>
                <td><input type='text' name='uk' style='width:99%' readonly='readonly' value=".$uk."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='northerneurope_st' style='width:99%' readonly='readonly' value=".$sub8."></td>
            </tr>

<!-- SOUTHERN EUROPE-->
            <tr>
                <td colspan=2>SOUTHERN EUROPE</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>GREECE</td>
                <td><input type='text' name='greece' style='width:99%' readonly='readonly' value=".$greece."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>ITALY</td>
                <td><input type='text' name='italy' style='width:99%' readonly='readonly' value=".$ita."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>PORTUGAL</td>
                <td><input type='text' name='portugal' style='width:99%' readonly='readonly' value=".$port."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SPAIN</td>
                <td><input type='text' name='spain' style='width:99%' readonly='readonly' value=".$spa."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>UNION OF SERBIA AND MONTENEGRO</td>
                <td><input type='text' name='uosam' style='width:99%' readonly='readonly' value=".$usm."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='southerneurope_st' style='width:99%' readonly='readonly' value=".$sub9."></td>
            </tr>

<!-- NORTHERN EUROPE-->
            <tr>
                <td colspan=2>NORTHERN EUROPE</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>COMMONWEALTH OF INDEPENDENT STATES</td>
                <td><input type='text' name='cois' style='width:99%' readonly='readonly' value=".$cis."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>POLAND</td>
                <td><input type='text' name='poland' style='width:99%' readonly='readonly' value=".$pol."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>RUSSIA</td>
                <td><input type='text' name='russia' style='width:99%' readonly='readonly' value=".$russ."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='nothernerope_st' style='width:99%' readonly='readonly' value=".$sub10."></td>
            </tr>

<!-- AUSTRALASIA/PACIFIC-->
            <tr>
                <td colspan=2>AUSTRALASIA/PACIFIC</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>AUSTRALIA</td>
                <td><input type='text' name='australia' style='width:99%' readonly='readonly' value=".$aust."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>GUAM</td>
                <td><input type='text' name='guam' style='width:99%' readonly='readonly' value=".$guam."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NAURU</td>
                <td><input type='text' name='nauru' style='width:99%' readonly='readonly' value=".$nauru."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NEW ZEALAND</td>
                <td><input type='text' name='newzealand' style='width:99%' readonly='readonly' value=".$zea."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>PAPUA NEW GUINEA</td>
                <td><input type='text' name='papuanewguinea' style='width:99%' readonly='readonly' value=".$pap."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td colspan=>SUB-TOTAL</td>
                <td><input type='text' name='australasia' style='width:99%' readonly='readonly' value=".$sub11."></td>
            </tr>

<!-- AFRICA-->
            <tr>
                <td colspan=2>AFRICA</td>
                <td>&nbsp</td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>NIGERIA</td>
                <td><input type='text' name='nigeria' style='width:99%' readonly='readonly' value=".$niger."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SOUTH AFRICA</td>
                <td><input type='text' name='southafrica' style='width:99%' readonly='readonly' value=".$sa."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>SUB-TOTAL</td>
                <td><input type='text' name='africa_st' style='width:99%' readonly='readonly' value=".$sub12."></td>
            </tr>

            <tr>
                <td colspan=2>OTHERS AND UNSPECIFIED</td>
                <td><input type='text' name='othersandunspecified' style='width:99%' readonly='readonly'></td>
            </tr>

            <tr>
                <td colspan=2>FOREIGN RESIDENCES</td>
                <td><input type='text' name='foreignresidencies' style='width:99%' readonly='readonly'></td>

            </tr>

<!-- TNFR-->
            <tr>
                <td colspan=2>TOTAL NON-PHILIPPINE RESIDENTS</td>
                <td><input type='text' name='t_nonphilresidents' style='width:99%' readonly='readonly' value=".$nonphil."></td>
            </tr>

<!-- OVERSEAS-->
            <tr>
                <td colspan=2>OVERSEAS FILIPINOS</td>
                <td><input type='text' name='overseesfiipinos' style='width:99%' readonly='readonly'></td>
            </tr>

<!-- GRAND TOTAL-->
            <tr>
                <td colspan=2>GRAND TOTAL GUEST ARRIVALS</td>
                <td><input type='text' name='Prov' style='width:99%' readonly='readonly' value=".$grandTotal."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>Total Philippine Residents</td>
                <td><input type='text' name='Prov' style='width:99%' readonly='readonly' value=".$philres."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>Total Non-Philippine Residents</td>
                <td><input type='text' name='Prov' style='width:99%' readonly='readonly' value=".$nonphil."></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>Total Overseas Filipinos</td>
                <td><input type='text' name='Prov' style='width:99%' readonly='readonly'></td>
            </tr>

            <tr>
                <td width='10%'>&nbsp</td>
                <td>Total Guests with Unspecified Residence</td>
                <td><input type='text' name='Prov' style='width:99%' readonly='readonly'></td>
            </tr>

      </table>
      </td>
      </tr>



</table>
</form>
</body>
</html>";
?>