alert('Record Searched!');"; $roomPerMonth=$roomPerMonth+1; $guestAvail=$guestAvail+$row[8]; } $tot="SELECT * FROM tblrooms where Accom='$_POST[AccomIden]' and Year='$_POST[year]' and Month='$_POST[month]'"; $total= mysql_query($tot); $has=0; while ($row=mysql_fetch_array($total)) { $has=$has+1; } $mon=date("F"); if($mon=="January"){ $multiplier=31; } else if($mon=="February"){ $multiplier=28; } else if($mon=="March"){ $multiplier=31; } else if($mon=="April"){ $multiplier=30; } else if($mon=="May"){ $multiplier=31; } else if($mon=="June"){ $multiplier=30; } else if($mon=="July"){ $multiplier=31; } else if($mon=="August"){ $multiplier=30; } else if($mon=="September"){ $multiplier=31; } else if($mon=="October"){ $multiplier=30; } else if($mon=="November"){ $multiplier=31; } else if($mon=="December"){ $multiplier=30; } else{ } if($has==0 || $guestAvail==0){ $occupancy=0; } else{ $occupancy=($has/($guestAvail*30)); } if($roomPerMonth==0 || $roomNums==0){ $roomPerMonth=0; } else{ $occupant=($roomPerMonth/($multiplier*$roomNums))*100 ; } mysql_close($con); include ("header.php"); echo" DAE 1A

Monthly Reporting Format for Accommodation Establishment

" ?>