= NOW() AND event.show=1 ORDER BY event.date ASC"; $results = ifs_query($SQL); if ($row = ifs_fetch_assoc($results)) { $evdate = $row['thedate']; $evtitle = $row['title']; $evloc = $row['city']; $evprov = fetchProvName($row['provstate']); $evpcountry = fetchCountryName($row['country']); $evothers = $row['otheracts']; if (!$evothers) $w=""; else $w="W/"; $tour_output = $evdate."
".$evtitle." - ".$evloc.", ".$evprov.", ".$evpcountry."
".$w." ".$evothers; if ( strlen($tour_output) >= 85) { for ($x=0; $x<= 87; $x++) { $tdisplay.= $tour_output[$x]; } $tdisplay.= "..."; } else $tdisplay = $tour_output; } else $tdisplay = "Dates to be announced soon!"; //fetch concert for NEWS $SQL="SELECT *, DATE_FORMAT(newsitem.date,'%b %e, %Y') as thedate FROM `newsitem` ORDER BY newsitem.date DESC"; $results = ifs_query($SQL); $row = ifs_fetch_assoc($results); $newsdate = $row['thedate']; $newshead = $row['headline']; $newstext = $row['newstext']; if ( strlen($newstext) >= 66) { for ($x=0; $x<= 63; $x++) { $ndisplay.= $newstext[$x]; } $ndisplay.= "..."; } else $ndisplay = $newstext; $news_output = $newsdate.": ".$newshead."
".$ndisplay; ?> In-Flight Safety // HALIFAX NS CANADA
In-Flight Safety

NEWS

ON TOUR

SITE BY JUD