ลองเข้ามาดูสักนิดครับ เผื่อได้แล้วจะมาเขียนบทความให้เกี่ยวกับปฏิทินกิจกรรม

function getDateLink($day, $month, $year)
    {
		//global $db ;
        // Only link the first day of every month 
        $link = "";
	#host config
	$host = "localhost";  //  Host
	$userdbname = "root";  // user name vrttenet_html
	$password = "12345";  //  password
	$dbname = "test";	// database

	#Connect Database
	$db_conn = mysql_connect($host,$userdbname,$password) or die ("can't connect DB");
	mysql_select_db($dbname,$db_conn);
	mysql_query("SET character_set_results=utf8");
	mysql_query("SET character_set_client=utf8");
	mysql_query("SET character_set_connection=utf8");
	date_default_timezone_set('Asia/Bangkok');	
	
		$sql_cal="select * from activity WHERE act_date_begin='".$year."-".$month."-".$day."' or act_date_end='".$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("\'", "'", $rs['act_detail']);
			$rs['act_detail'] = htmlspecialchars($rs['act_detail']);
			$link['title'] = "".stripslashes($rs['act_name'])."";
        }
        return $link;
    }