ปฏิทินกิจกรรม แสดงวันที่จัดกิจกรรมให้ครบทุกวันที่จัดกิจกรรม

class Calendar
{	
    	while ($d <= $daysInMonth)
    	{
    	    $s .= "<tr>\n";       
    	    
    	    for ($i = 0; $i < 7; $i++)
    	    {
        	    $class = ($year == $today["year"] && $month == $today["mon"] && $d == $today["mday"]) ? "calendarToday" : "calendar";
    	        $s .= "<td class=\"$class\" align=\"right\" valign=\"top\">";       
    	        if ($d > 0 && $d <= $daysInMonth)
    	        {
    	            $link = $this->getDateLink($d, $month, $year);
    	            //Date link here
					$s .= (($link == "") ? $d : "<a href=".$link['link']." title=\"คลิกเพื่อดู  $link[title]\" id=\"view_act\"><img src=\"img/orther/pin.png\" style=\"position:absolute; margin-top:-5px; margin-left:-7px;\" ><B><u><font color='#FF0000'>$d</font></u></B></a>");
    	        }
    	        else
    	        {
    	            $s .= "&nbsp;";
    	        }
      	        $s .= "</td>\n";       
        	    $d++;
    	    }
    	    $s .= "</tr>\n";    
    	}
    	
    	$s .= "</table>\n";
    	
    	return $s;  	
    }

class MyCalendar extends Calendar
{
	function getCalendarLink($month, $year)
    {
        $s = getenv('SCRIPT_NAME');
        return "$s?news=calendar&year=$year";
	} 
    function getDateLink($day, $month, $year)
    {
        $link = "";
		include"connect.php";
		$sql_cal="select * from activity WHERE act_date_begin='".$year."-".$month."-".$day."' ";
		$result_cal=mysql_db_query($dbname,$sql_cal);
		$rs=mysql_fetch_array($result_cal);
		
		if ($rs)
		 {
            $link['link'] = "view_activity.php?act_id=".$rs['act_id']."";
			$rs['act_detail'] = eregi_replace("\'", "&#039;", $rs['act_detail']);
			$rs['act_detail'] = htmlspecialchars($rs['act_detail']);
			$link['title'] = "".stripslashes($rs['act_name'])."";
        }
        return $link;
    }
}