Availability Calendar

[tripwire8]

I'm creating an availability calendar for a cottage which displays all the days for each month in a normal calendar format. For each day that is booked I want it to be coloured red and for each day that isn't booked I want it to be coloured green. I'm storing the booking information in mysql based on the arrival date and a numerical value representing the number of days booked to stay.

Now, I've got each day to respond to the arrival date but I can't for the life of me figure out how to get the rest of the days following the arrival date to represent being booked and thus coloured red.

Here's what I have so far.

<table width="631" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr class="topdays">
    <td><div align="center">Saturday</div></td>
          <td><div align="center">Sunday</div></td>
          <td><div align="center">Monday</div></td>
          <td><div align="center">Tuesday</div></td>
          <td><div align="center">Wednesday</div></td>
          <td><div align="center">Thursday</div></td>
          <td><div align="center">Friday</div></td>
        </tr>
		<tr valign="top" bgcolor="#CCCCCC"> 
		<?
		for ($i = 1; $i <= $first_day_of_month; $i++) {
			$days_so_far = $days_so_far + 1;
			$count_boxes = $count_boxes + 1;
			echo "<td width=\"100\" height=\"125\" class=\"beforedayboxes\"></td>\n";
		}
		for ($i = 1; $i <= $days_in_month; $i++) {
   			$days_so_far = $days_so_far + 1;
    			$count_boxes = $count_boxes + 1;
			IF($_GET['month'] == $todays_month+1){

			IF($i == $todays_date){
				$class = "highlighteddayboxes";

			} ELSE {
				$class = "dayboxes";
			}
		} ELSE {
			IF($i == 1){
				$class = "highlighteddayboxes";
			} ELSE {
				$class = "dayboxes";
			}
		}


IF(isset($events[$i])){
while (list($key, $val) = each ($nightstay[$i])) {

				$class = "calendarbooked";			

}
}

		echo "<td width=\"100\" height=\"125\" class=\"$class\">\n";
		$link_month = $_GET['month'] - 1;
		echo "<div align=\"right\"><span class=\"toprightnumber\">\n$i&nbsp;</span></div>\n";
		IF(isset($events[$i])){
			echo "<div align=\"left\"><span class=\"eventinbox\">\n";
			while (list($key, $value) = each ($events[$i])) {
								}
			echo "</span></div>\n";
		}
		echo "</td>\n";
		IF(($count_boxes == 7) AND ($days_so_far != (($first_day_of_month-1) + $days_in_month))){
			$count_boxes = 0;
			echo "</TR><TR valign=\"top\">\n";
		}
	}
	$extra_boxes = 7 - $count_boxes;
	for ($i = 1; $i <= $extra_boxes; $i++) {
		echo "<td width=\"100\" height=\"125\" class=\"afterdayboxes\"></td>\n";
	}
	$time_end = getmicrotime();
	$time = round($time_end - $time_start, 3);
	?>
  </tr>
</table>

Any help would be greatly appreciated.
Thanks.

[tripwire8]

Ok, I've got a little further with displaying the booked days following the arrival date. I decided to loop through the number of booked days and store the information in a session variable array. The problem now is that when looping through each datebase record the following information seems to be overwriting my session array. How do I store all of my booked days in the same session variable?

Here is what I added.

if ($session['bookddays']) { }
else {
$_SESSION['bookeddays']=array();
}

if ($nights > 1) {
	for ($i = 1; $i <= $nights; $i++) {

		   $j = $i+$unshiftday;

		$_SESSION['bookeddays'][$j]=$day2;	

	$day2 = $day2+1;

       }

					 }

[tripwire8]

I decided to created multiple session arrays based on each id. I think I almost have this working, but I'm having some trouble looping through the arrays. The interation values arn't corresponding to call up the proper values. Is there a better way to loop through and display all the data in my multiple arrays?

This is what I've got.

$event_idz = 0;

	for ($i = 1; $i <= $first_day_of_month; $i++) {


//loops through booked days

$bookeddays = $_SESSION[$event_idz][$j];

			IF($i == $bookeddays){
				$class = "calendarbooked";
			} ELSE {
				$class = "calendaravailable";
				$event_idz = $event_idz + 1;
			}
}