include("includes/config.php");
include("includes/conn.php");
$sql_anmnt_query = "SELECT * FROM tbl_announcements ORDER BY anmnt_date DESC";
$sql_anmnt_result = mysql_query($sql_anmnt_query) or die("Query failed : " . mysql_error());
$num_rows = mysql_num_rows($sql_anmnt_result);
$display_anmnt ="";
if ($num_rows > 0){
$display_anmnt .="
";
$display_anmnt .="";
$display_anmnt .="| Sr.No | ";
$display_anmnt .="Announcements | ";
$display_anmnt .="Date and Time | ";
$display_anmnt .="
";
$display_anmnt .="";
$display_anmnt .="
| ";
$display_anmnt .=" |
";
$num_row=1;
while ($sql_anmnt_rows = mysql_fetch_array($sql_anmnt_result, MYSQL_ASSOC)) {
//$i++;
$display_anmnt .="";
$display_anmnt .="| ".$num_row++." | ";
$display_anmnt .="".$sql_anmnt_rows[anmnt_title]." | ";
$display_anmnt .="".date("dS F Y H:i:s",strtotime($sql_anmnt_rows[anmnt_date]))." | ";
$display_anmnt .="
";
}
$display_anmnt .="
";
}else{
$display_anmnt .="