query($ad_query); $n = $adres->num_rows; if ($n>0) { // there is a result set, so proceed to get the zone/ad $z = "select zone from cms_site_content where id=1"; $zres = $etomite_db->query($z); $row = $zres->fetch_array(); $ad = $row["zone"]; } else { $ad = false; } ==================================*/ $z = "select zone from cms_site_content where id=1"; $zres = $etomite_db->query($z); $row = $zres->fetch_array(); $ad = $row["zone"]; // REPLACE ADSERVER INVOCATION WITH AD FROM ARRAY $n = count($active_ads) - 1; $number_list = range(0, $n); shuffle($number_list); // key to list of ads in random order // use first number in $numbers as array key to get ad for this page $ad_key = $number_list[0]; $ad = $active_ads[$ad_key]; $numbers = implode("", $number_list); //echo "n=".$n." ad_key=".$ad_key." numbers=".$numbers."
"; // exclude article used as feature $result = $etomite_db->query("select home from featured_articles where db_id=1"); $row = $result->fetch_array(); $exclude_id = $row["home"]; // query to concatenate towns into comma-sep list $q = "select cms_site_content.id, cms_site_content.parent, cms_site_content.alias, FROM_UNIXTIME(cms_site_content.createdon, '%M %e, %Y') as dateline, cms_site_content.pagetitle, cms_site_content.zone, cms_site_content.thumbnail, GROUP_CONCAT(cms_site_towns.town) town FROM cms_town_xref INNER JOIN cms_site_content ON cms_town_xref.content_id = cms_site_content.id INNER JOIN cms_site_towns ON cms_town_xref.town_id = cms_site_towns.id where cms_site_content.parent in (2, 3, 4) and cms_site_content.published=1 and cms_site_content.deleted=0 and cms_site_content.showinmenu=1 and cms_site_content.pub_date<".time()." and cms_site_content.id<>$exclude_id GROUP BY cms_site_content.id order by createdon desc limit 9"; $res = $etomite_db->query($q); echo '"; ?>