Is This Possible?

Static_Cling

After doing some searching and research, I've been able to devlop a rudementary calendar app/db for rental availability. Now, what I am wondering is it possible to run a select statment to give me all of the days where a rental property is booked, and then have those days highligted on the calendar?

Right now, my code is just displaying the calendar, but I have the sql statment there that pulls the data, just trying to find a way to add the highlight and results into this code:

echo "
<table border='1'>
<tr align='center' border='0'>
<td align='center' colspan='7'>
<font size='3'>$This_Month $This_Year</font>
</td>
</tr>
<tr>
<td colspan='1' align='right'>
<tr>
<td width='$col_width' align='center'>
Sun
</td>
<td width='$col_width' align='center'>
Mon
</td>
<td width='$col_width' align='center'>
Tue
</td>
<td width='$col_width' align='center'>
Wed
</td>
<td width='$col_width' align='center'>
Thu
</td>
<td width='$col_width' align='center'>
Fri
</td>
<td width='$col_width' align='center'>
Sat
";
//Next, we draw the calendar body
$rowcount="1";
$daycount="1";
$calendar_day=0;
while ($rowcount<=$rows)
{
echo "<tr>";
$day_column=1;
while ($day_column<=7)
{
echo "<td>";
if ($daycount<$startpos)
echo " ";
elseif (($daycount-$startpos+1)>$days)
echo " ";
else
{
$calendar_day=$calendar_day+1;
echo "$calendar_day";
}
$daycount=$daycount+1;
echo "</td>";
$day_column=$day_column+1;
}
echo "</tr>";
$rowcount=$rowcount+1;
}

//Finally, we finish the table
echo "</table>";

Nate

I would do your query and put all of the 'booked' results into an array like:

array (
   [0] = date
   [1] = date
   [2] = date
)

Then, in the code that draws your calendar, you simple check the date in the array against the date you're drawing and if it exists, you highlight it.

gubatron

more specifically an associative array, just making sure you won't do a look up on a regular array.

So you'd have somethin like:

$dates = array('date1'=>1,'date2' =>2,...,'dateN' =>3);

where date1 can be something like 'mmddyy',
then as you go through the printing process of your TDs, you check:

 if (isset($dates[$month . $day . $year])) { //highlight in anyway you want... I recommend you add a class="booked" in css to your tag and then you define the style on CSS }

Gubatron