require_once($_SERVER['DOCUMENT_ROOT']."/site_includes/TimminsTourism.php"); ?> $ID=1; if ($g_LangPref=="_fr") { $TopMenuSqlQuery = "SELECT Title_fr AS Title, id from Sections WHERE Status = 'A' AND ParentID = id AND NOT id = 1 ORDER BY id "; } else { $TopMenuSqlQuery = "SELECT * from Sections WHERE Status = 'A' AND ParentID = id AND NOT id = 1 ORDER BY id "; } $TopMenuSqlResult = mysql_query($TopMenuSqlQuery) or die("Query Error: ."); $TopMenuRowCount = mysql_num_rows($TopMenuSqlResult); if ($g_LangPref=="_fr") { $NewsSqlQuery = "SELECT Title_fr AS Title, Content_fr AS Content, Intro_fr AS Intro, id, NewsDate from News WHERE Status = 'A' ORDER BY Rank DESC Limit 1"; } else { $NewsSqlQuery = "SELECT * from News WHERE Status = 'A' ORDER BY Rank DESC Limit 1"; } $NewsSqlResult = mysql_query($NewsSqlQuery) or die("Query Error: ."); $NewsRowCount = mysql_num_rows($NewsSqlResult); if ($g_LangPref=="_fr") { $PageInfoSqlQuery = "SELECT Title_fr AS Title, Content_fr AS Content from Sections WHERE Status = 'A' AND id = " . $ID; } else { $PageInfoSqlQuery = "SELECT * from Sections WHERE Status = 'A' AND id = " . $ID; } $PageInfoSqlResult = mysql_query($PageInfoSqlQuery) or die("Query Error:..... "); $PageInfoRowCount = mysql_num_rows($PageInfoSqlResult); if ($g_LangPref=="_fr") { $HomePageImagesQuery = "SELECT ImageText1_fr AS ImageText1, ImageText2_fr AS ImageText2, Image, Thumbnail from homepageimages WHERE Active = 'Y'"; } else { $HomePageImagesQuery = "SELECT * from homepageimages WHERE Active = 'Y'"; } $HomePageImagesResults = mysql_query($HomePageImagesQuery) or die("Query Error: "); $NumHomePageImages = mysql_num_rows($HomePageImagesResults); $PageInfoRow = mysql_fetch_array($PageInfoSqlResult); $whichMenu = 'leftMenu.txt'; ?>