tblNewsCategory.NewsCategoryID"; $Menurs = $db->Execute($MenustrSQL); $MenusubcategoriesRS = $Menurs; $arr = $MenusubcategoriesRS->GetArray(); $MenusubcategoriesArr = $arr; $Menusubcattotal = $MenusubcategoriesRS->RowCount(); function my_date_format($mydate) { $mydatetimearray = split(" ",$mydate); $mydatearray = split("-",$mydatetimearray[0]); $result = $mydatearray[2]."/".$mydatearray[1]."/".$mydatearray[0]; return $result; } $today = date("Y-m-d h:i:s"); $newsID = $_GET["i"]; if ($newsID == "") { header("Location: "."categories.php"); } //News Details $sqlstmt="SELECT tblNewsDetails.NewsID, tblNewsDetails.NewsTitle, tblNewsDetails.NewsSummary, tblNews.NewsDate, tblNewsDetails.NewsContent FROM tblNews, tblNewsDetails WHERE tblNews.NewsID = tblNewsDetails.NewsID AND (#".$today."# BETWEEN tblnews.validfrom AND tblnews.validto) AND tblNews.NewsID = ".$newsID." ORDER BY tblNews.NewsDate DESC"; //echo $sqlstmt; $rs = $db->Execute($sqlstmt); $NewssRS = $rs; $arr = $NewssRS->GetArray(); $NewssArr = $arr; $newstotal = $NewssRS->RowCount(); ?>

Back This News Item is not available anymore. Back