<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  require_once "/home/content/a/d/c/adcsitework/html/cmsAdmin/lib/viewer_functions.php";

  list($publicprojectsRecords, $projectsMetaData) = getRecords(array(
    'tableName'   => 'all_projects',
    'where'       => 'access = "public"'
  ));

  list($privateprojectsRecords, $projectsMetaData) = getRecords(array(
    'tableName'   => 'all_projects',
    'where'       => 'access = "private"'
  ));

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Projects - Public and Private</title>
<style type="text/css" >
<!--
@import url("/css/styles.css");
-->
</style>
<?php include("inc/jquery.php"); ?>
<?php include("inc/basic_js.php"); ?>
<script type="text/javascript" src="/js/p7_eqCols2_10.js"></script>
<link rel="shortcut icon" href="/favicon.ico">
</head>
<body>
<?php include("inc/lte_IE6.php"); ?>
<?php include("inc/header.php"); ?>
<div id="content">stuff goes here</div>
         <div id="col2">
         <h1>Projects</h1>
              <p>Residential, Commercial &amp; Highway Turnkey Site Construction<br />
<br />
Below is an overview of some of our current large scale projects, however, we perform work on projects of smaller scale as well.</p>

<?php foreach ($publicprojectsRecords as $record): ?>
            <h3><?php echo $record['title'] ?></h3>
      <p><?php echo $record['content'] ?></p>
      acccess: <?php echo $record['acccess'] ?>
      <hr/>
    <?php endforeach; ?>
    <?php if (!$publicprojectsRecords): ?>
      No public projects were found!<br/><br/>
    <?php endif ?>
    
    <!-- next record -->
    <?php foreach ($privateprojectsRecords as $record): ?>
       <h3><?php echo $record['title'] ?></h3>
      <p><?php echo $record['content'] ?></p>
      acccess: <?php echo $record['acccess'] ?>
      <hr/>
    <?php endforeach; ?>
    <?php if (!$privateprojectsRecords): ?>
      No private projects were found!<br/><br/>
    <?php endif ?>
         <!-- leave p for cols -->
      <p></p></div>
</div>
<?php include("inc/footer.php"); ?>
<?php include("inc/GA.php"); ?>
</body>
</html>
