function sCalendar($year, $month, $day_offset = 0){ $days = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"); $months = array("january","february","march","april","may","june","july","august","september","october","november","december"); $day_offset = $day_offset % 7; $start_day = gmmktime(0,0,0,$month,1,$year); $start_day_number = date("w",$start_day); $days_in_month = date("t",$start_day); $final_html .= "\n\n"; for($x=0;$x<=6;$x++){ $final_html .= ""; } $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 .= ""; } else { $final_html .= ""; } } while((($days_in_month+$blank_days)%7)!=0){ $final_html .= ""; $days_in_month++; } $final_html .= "\n
".strtoupper($months[$month-1])." $year
".$days[($x+$day_offset)%7]."
 
$x$x 
"; 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; }