"; echo ""; if(isset($_POST['done'])){ $anTitle = mysql_escape_string($_POST['anTitle']); $anSubTitle = mysql_escape_string($_POST['anSubTitle']); $ahDescription = mysql_escape_string($_POST['ahDescription']); $startDate = mysql_escape_string($_POST['startDate']); $endDate = mysql_escape_string($_POST['endDate']); mysql_query("INSERT INTO ahg_announcement (title, sub_title, description,start_date,end_date,deleted) VALUES('{$anTitle}','{$anSubTitle}','{$ahDescription}','{$startDate}','{$endDate}','0')"); } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getNews = mysql_query("SELECT * FROM `ahg_announcement` WHERE `end_date`> '$myDate' ORDER BY `end_date` DESC"); while($row=mysql_fetch_array($getNews)){ ?>".strtoupper($row['id']).""; echo ""; echo ""; echo ""; echo ""; echo ""; echo""; echo ""; $compRate=0; } echo "

NO.	TITLE.	SUB-TITLE	DESCRIPTOIN	START DATE	END DATE
".strtoupper($row['title'])."	".strtoupper($row['sub_title'])."	".strtoupper($row['description'])."	".strtoupper($row['start_date'])."	".strtoupper($row['end_date'])."

"; ?>