include("cms/adodb/adodb.inc.php");
include('cms/includes/dbconnect.php');
$RootCategoryID = 1;
$MenustrSQL="SELECT tblNewsCategoryDetails.NewsCategoryName, tblNewsCategory.NewsCategoryID FROM tblNewsCategory, tblNewsCategoryDetails WHERE tblNewsCategoryDetails.NewsCategoryID = tblNewsCategory.NewsCategoryID AND tblNewsCategory.parentCategoryID = ".$RootCategoryID." AND tblNewsCategory.parentCategoryID <> 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();
?>
CyberGaming Consultants Malta-online gaming/remote gaming consultants in Malta