\n| ".strtoupper($months[$month-1])." $year |
\n";
for($x=0;$x<=6;$x++){
$final_html .= "".$days[($x+$day_offset)%7]." | ";
}
$final_html .= "\n";
$blank_days = $start_day_number - $day_offset;
if($blank_days<0){$blank_days = 7-abs($blank_days);}
for($x=0;$x<$blank_days;$x++){
$final_html .= " | ";
}
for($x=1;$x<=$days_in_month;$x++){
if(($x+$blank_days-1)%7==0){
$final_html .= "\n";
}
$row_count = sappointmentCheck($month,$x,$year);
if($row_count == 0){
$final_html .= "| $x | ";
} else {
$final_html .= "$x | ";
}
}
while((($days_in_month+$blank_days)%7)!=0){
$final_html .= " | ";
$days_in_month++;
}
$final_html .= "
\n";
return($final_html);
}
function sappointmentCheck($cmonth,$cday,$cyear){
$query = "SELECT * FROM appointments WHERE (month='$cmonth' && day='$cday' && year='$cyear')";
$run_it = mysql_query($query) or die(mysql_error());
$result_int = mysql_num_rows($run_it);
return $result_int;
}
?>