".$ename."
"; } else if(!empty($eaddress)) { $latlon = "a^".$eaddress; $mkBuild .= "".$ename."
"; } } } echo $mkBuild; } function getEvents(){ $mkBuild = null; $thisYear = date('Y'); $sql = "select * from forms.nno where status = 'approved' and nnoyear = '$thisYear' order by eventname"; $reslt = pg_query($sql); $mkCount = pg_num_rows($reslt); $comma = ","; while ($arr = pg_fetch_array($reslt,NULL,PGSQL_BOTH)) { $lat = $arr['latbox']; $lon = $arr['lonbox']; $ename = $arr['eventname']; $estart = $arr['eventstart']; $eend = $arr['eventend']; $eaddress = $arr['eventaddress']." Pittsburgh, PA "; $bubble = $ename ."
Starting at: ".$estart."
To:".$eend; if (!empty($lat) || !empty($lot)){ $mkBuild .= "{ latitude: ".$lat.",longitude: ".$lon.", html:{content: '".$bubble."'} },"; } else if(!empty($eaddress)) { $mkBuild .="{address: '".$eaddress."',html:{content: '".$bubble."'} },"; } } return $mkBuild; } ?>
"; getContentBlockbyID('443'); ?>
Event Map