<?php
  // include shared code
  include '../lib/common.php';
  include '../lib/db.php';
  
  // determine current viewed month and year
  $timestamp\; =\; (isset($_GET['t'])) ? $\_GET[\text{'}t\text{'}]\; :\; time();\; list($month, $year)\; =\; explode(\text{'}/\text{'},\; date(\text{'}m/Y\text{'},$timestamp));
  
  // Javascript references
  <script src="js/ajax.js" type="text/javascript"></script>
  <script src="js/blog.js" type="text/javascript">
  ENDHTML;
  
  // retrieve entries for currently viewed month
  query = sprintf('
      SELECT
          POST_ID, POST_TITLE, POST_TEXT,
          UNIX_TIMESTAMP(POST_DATE) AS POST_DATE
      FROM
          \%sBLOG_POST
      WHERE
          DATE(POST_DATE) BETWEEN
              "\%d-%02d-01" AND 
              DATE("\%d-%02d-01") + INTERVAL 1 MONTH - INTERVAL 1 DAY
      ORDER BY
          POST_DATE DESC',
      DB_TBL_PREFIX,
      $year,$month,
      $year,$month);
  $result\; =\; mysql\_query($query, $GLOBALS[\text{'}DB\text{'}]);\; ob\_start();\; while\; ($record = mysql_fetch_assoc($result))\; \{\; echo\; \text{'}$<h2>' . record['POST_TITLE'] . '</h2>';
      echo '<p>' . date('m/d/Y', $record[\text{'}POST\_DATE\text{'}])\; .\; \text{'}$</p>';
      echo record['POST_TEXT'];
      echo '<div style="display:none;" id="comments_' . $record[\text{'}POST\_ID\text{'}]\; .\; \text{'}">$</div>';
      echo '<p><a href="#" onclick="toggleComments(' . record['POST_ID'] . 
          ', this);return false;">Show Comments</a></p>';
      echo '<hr/>';
  }
  mysql_free_result($result);$// generate link to view previous month if appropriate
  query = sprintf('SELECT UNIX_TIMESTAMP(POST_DATE) AS POST_DATE ' .
      'FROM \%sBLOG_POST ORDER BY POST_DATE DESC',
       DB_TBL_PREFIX);
  $result\; =\; mysql\_query($query, $GLOBALS[\text{'}DB\text{'}]);\; if\; (mysql\_num\_rows($result))
  {
  
      // determine date of newest post
      $row\; =\; mysql\_fetch\_assoc($result);
      $newest\; =$row['POST_DATE'];
  
      // determine date of oldest post
      mysql_data_seek($result,\; mysql\_num\_rows($result) - 1);
      $row\; =\; mysql\_fetch\_assoc($result);
      $oldest\; =$row['POST_DATE'];
  
      if ($timestamp\; >$oldest)
      {
          echo '<a href="' . htmlspecialchars($\_SERVER[\text{'}PHP\_SELF\text{'}])\; .\; \text{'}?t=\text{'}\; .\; strtotime(\text{'}-1\; month\text{'},$timestamp) . '">Prev</a> ';
      }
  
      if (newest)
      {
          echo ' <a href="' . htmlspecialchars($\_SERVER[\text{'}PHP\_SELF\text{'}])\; .\; \text{'}?t=\text{'}\; .\; strtotime(\text{'}+1\; month\text{'},$timestamp) . '">Next</a>';
      }
  
  }
  mysql_free_result($result);$// link to RSS feed
  GLOBALS['TEMPLATE']['head_extra'] = '<link rel="alternate" ' . 
      'type="application/rss+xml"  href=<rss.php> title="My Blog">';
  
  echo '<p><a href=<rss.php>>RSS Feed</a></p>';
  $GLOBALS[\text{'}TEMPLATE\text{'}][\text{'}content\text{'}]\; =\; ob\_get\_clean();\; include\; \text{'}../templates/template-page.php\text{'};\; mysql\_close($GLOBALS['DB']);
  ?>