background

Archive -

=$varGETYear2 ORDER BY `tblm_News`.`NDate` DESC"; $result_CountNews = mysqli_query($dbcon, $query_CountNews); $row_CountNews = mysqli_num_rows($result_CountNews); $query_LoadNews = "SELECT `tblm_News`.* FROM `tblm_News` WHERE `tblm_News`.`NDisplay`=1 AND YEAR(`tblm_News`.`NDate`)<=$varGETYear AND YEAR(`tblm_News`.`NDate`)>=$varGETYear2 ORDER BY `tblm_News`.`NDate` DESC LIMIT " . $offset . "," . $items_per_page; $result_LoadNews = mysqli_query($dbcon, $query_LoadNews); while ($row=mysqli_fetch_assoc($result_LoadNews)) { $varNID = $row["NID"]; $varNName = $row["NName"]; $varNDetails = $row["NDetails"]; $varNDate = $row["NDate"]; $varNType = $row["NType"]; if ($varNType==1) { $varNTypeDisplay = "Press & Speech Releases"; } if ($varNType==2) { $varNTypeDisplay = "RAS News"; } if ($varNType==4) { $varNTypeDisplay = "Events"; } if ($varNType==4) { $varNTypeDisplay = "RAS e-Newletters"; } $varNDateDisplay = date("d M Y", strtotime($varNDate)); ?>