"; $links = ""; include("/var/www/PHPwebsite/olde_header.php"); // includes the database require_once('/var/www/zdata/webapps/route_setup.php'); $date = date('m/d/Y'); ?>

$section); $p = $db->prepare($q); $p->execute($sqlVars); $result = $p->fetchAll(PDO::FETCH_ASSOC); $trans_array = array(); $x = 0; foreach ($result as $row) { $trans_array[$row['pc_id']][$x]['country'] = $row['country']; $trans_array[$row['pc_id']][$x]['link'] = $row['tr_link']; $x++; } return $trans_array; } function loadArticles ($section) { global $db; $trans_array = getTranslationLinks($section); $q = "SELECT * FROM exacq_presscenter WHERE section=:section ORDER BY date DESC"; $sqlVars = array(":section" => $section); $p = $db->prepare($q); $p->execute($sqlVars); $result = $p->fetchAll(PDO::FETCH_ASSOC); $html = ""; // html string $htmls = ""; // html string $prevDate = ""; $i = 0; foreach ($result as $row) { $date = new DateTime($row['date']); $exDate = explode("-", $row['date']); // Y-m-d $exPrevDate = explode("-", $prevDate); // if this date does not equal the previous date display a date header if ($exDate[0] != $exPrevDate[0]) { if ($i == 0) { $html .= "
".$exDate[0]."
"; } else { $html .= "
".$exDate[0]."
top ↑
"; } } $html .= "
".$date->format("F d"); if (@$row['author']) { $html .= " - ".$row['author'].""; } $html .= "
".$row['title']."
".$row['description']."
"; $translations = @$trans_array[$row['id']]; // check to make sure we have an array if (is_array($translations)) { $html .= "
"; foreach ($translations as $each) { $country = $each['country']; $link = $each['link']; $html .= "
  • ".$country."
    ".$link."
    • "; } $html .= "
    "; } $html .= "
    "; $prevDate = $row['date']; $i++; } return $html; } ?>