Long Island
By: Leah Hatch
With the Olympics right around the corner we’re all looking for a place to grab a bite and watch the world compete in Paris. With 45 different sports to watch, there’s something everyone will enjoy. And this year’s Olympics is making history as the first Olympics with an equal number of men and women competing for the gold! Check out these spots starting July 26th and catch the world’s best athletes go head-to-head in Paris.
July 24, 2024 | What To Do
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;
}
// 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 '
';
// args: db result, string for ad, page number, id of featured page to be excluded
$this_id = 1; // for home page. lazy load takes this into account in query for parent id to use
output_card_collection($res, $ad, 1, $exclude_id, $this_id);
echo "
";
?>