require("modules.php");
//# To load values
$intViewYear = $_REQUEST["intViewYear"];
?>
 |

Announcements
//# To loop every announcement in the database.
$strQuery = "SELECT AN.ANID,AN.anDate,AN.anTitle,AN.anPageURL
FROM tblAnnouncements AN
WHERE LEFT(AN.anDate,4)='$intViewYear'
ORDER BY AN.ANID DESC";
//echo $strQuery . " ";
//$result1 = mysql_query($strQuery);
$result1 = mysqli_query($mysqli,$strQuery);
//echo "HELLO: $result1 ";
//echo "Rows: " . mysqli_num_rows($result1);
if ($result1) {
//echo "HELLO: $result1 ";
if (mysqli_num_rows($result1) > 0) {
?>
while (list($ANID,$anDate,$anTitle,$anPageURL) = mysqli_fetch_row($result1)) {
?>
|
echo fnSetDateFormat($anDate,"yyyy-mm-dd","dd-mm-yyyy"); ?> |
|
}
?>
}
}
?>
include("footer.php"); ?>
|