include("cms/adodb/adodb.inc.php"); include('cms/includes/dbconnect.php'); 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"); //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.featured = Yes) ORDER BY tblNews.NewsDate DESC"; //echo $sqlstmt; /* $rs = $db->Execute($sqlstmt); $NewssRS = $rs; $arr = $NewssRS->GetArray(); $NewssArr = $arr; $newstotal = $NewssRS->RowCount(); */ ?>
|