Tom_11 0 Newbie Poster

I was hoping i could get some help in regards to a time slot calendar i am working on. I have created a calendar in php.

I need a key for the calendar which shows what days are:

Available to be book
Partially booked
Fully booked
Closed
All on a certain day, this is all done with the sql database.

Can anyone help me on how to do this?

My calendar code is below:

 $monthNames = Array("January", "February", "March", "April", "May",    
  "June", "July", "August", "September", "October", "November", "December");
   ?>

 <?php
 if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n");
 if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y");
 ?>

<?php
$cMonth = $_REQUEST["month"];
$cYear = $_REQUEST["year"];
$prev_year = $cYear;
$next_year = $cYear;
$prev_month = $cMonth-1;
$next_month = $cMonth+1;
if ($prev_month == 0 ) {
$prev_month = 12;
$prev_year = $cYear - 1;
}
if ($next_month == 13 ) {
$next_month = 1;
$next_year = $cYear + 1;
}
?>

 <div align="left">
 <table width="400" border="5" align="left" id="calendar">
 <tr align="center">
 <td bgcolor="#999999" style="color:#FFFFFF"><table width="100%" border="0"    
 cellspacing="0" cellpadding="0">
 <tr>
 <td width="50%" align="left"><a href="<?php echo $_SERVER["PHP_SELF"]   
 . "?month=". $prev_month . "&year=" . $prev_year; ?>"  
 style="color:#FFFFFF">Previous</a></td>
 <td width="50%" align="right"><a href="<?php echo $_SERVER["PHP_SELF"]   
 . "?month=". $next_month . "&year=" . $next_year; ?>"    
 style="color:#FFFFFF">Next</a></td>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td align="center"><table width="100%" border="2" cellpadding="2"   
 cellspacing="2">
 <tr align="center">
 <td colspan="7" bgcolor="#999999" style="color:#FFFFFF"><strong> <?php  
 echo $monthNames[$cMonth-1].' '.$cYear; ?></strong></td>
 </tr>
 <tr>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">  
 <strong>S</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">  
 <strong>M</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">
 <strong>T</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">  
 <strong>W</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">   
 <strong>T</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">
 <strong>F</strong></td>
 <td align="center" bgcolor="#999999" style="color:#FFFFFF">
 <strong>S</strong></td>
 </tr>

 <?php
 $timestamp = mktime(0,0,0,$cMonth,1,$cYear);
 $maxday = date("t",$timestamp);
 $thismonth = getdate ($timestamp);
 $startday = $thismonth['wday'];
 $today = getdate();

 for ($i=0; $i<($maxday+$startday); $i++) {

 if(($i % 7) == 0 ){
 echo "<tr> ";
}

if($i < $startday){
echo "<td></td> ";
} else{
$jsEvent[] = "document.getElementById('trigger" . $i . "').onclick =     
function() {showForm()};";     

 echo "<td align='center' valign='middle' height='20px'><a href='#'    
 id='trigger" . $i . "'>". ($i - $startday + 1) . "</a></td>"; 
 }

 if(($i % 7) == 6 ){
  echo "</tr> ";
 }
 }
?>

<script type="text/javascript">
<?php foreach($jsEvent as $event){
        echo $event;
     } ?>
 function showForm(){
     document.getElementById('timeslots').style.display="block";
  };
 </script>
</table></td>
</tr>
</table>