totalAssign = 6ppl
Adults = 2
Children = 4
Room = 2
split them equaly in each room
averagePpl = round(6/2) // 6ppl / 2rooms then round it up
Note: averagePpl can be ur numbers of bed in a room.
RemAssign = totalAssign
RemAdultsAssign = adults
RemChildrenAssign = Children
foreach($rooms as $roomnumber){
'assume that adults always set as priority then only children
if RemAdultsAssign > averagePpl {
$adults = averagePpl
$remAdultsAssign
= $RemAdultsAssign - $averagePpl
$Remassign = $Remassign - $averagePpl
}else{
$adults = $RemAdultsAssign
$Remassign = $Remassign - $RemAdultsAssign
$remAdultsAssign
= 0
}
//same concept goes to $children
$insertSQL = "INSERT INTO bookings (roomNumber, adults, children) VALUES ( '$roomnumber', '$adults', '$children')";
$Result1 = mysql_query($insertSQL) or die(mysql_error());
}