function setAvailability($DayFrom, $DayTo, $IDroom, $Available)
{
$myDates = array();
$sql = "SELECT Dates FROM availability WHERE Dates >= '" . $DayFrom . "' AND Dates < '" . $DayTo . "'";
$result = mysql_query($sql);
$j = 0;
while ($row = mysql_fetch_array($result)) {
$dates[$j] = $row['Dates'];
$j++;
}
$myDates = makemyday($DayFrom, $DayTo);
$counter = count($myDates);
for ($i = 0; $i < $counter; $i++) {
if (contein($myDates[$i], $dates)) {
mysql_query("UPDATE availability SET `" . $IDroom . "` = '" . $Available . "' WHERE Dates = '" . $myDates[$i] . "'");
} else {
mysql_query("INSERT INTO `availability` (Dates, `" . $IDroom . "`) VALUES ('" . $myDates[$i] . "', '" . $Available . "')");
}
}
}
function roomCost($From, $To, $RoomID)
{
$dates = array();
$cost = array();
$dates = makemyday($From, $To);
$i = count($dates);
$z = 0;
for ($x = 0; $x < $i; $x++) {
$sql2 = "SELECT * FROM `room" . $RoomID . "prices` WHERE `From` <= '" . $dates[$x] . "' AND `To` >= '" . $dates[$x] . "' ";
$result2 = mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2)) {
$cost[$z] = $row2['Price'];
$z++;
}
}
$OveralCost = 0;
for ($k = 0; $k < $z; $k++) {
$OveralCost = $OveralCost + $cost[$k];
}
return $OveralCost;
}
