require('inc_header.php');
if ((isset($_GET['MONTH'])) & (isset($_GET['YEAR'])))
$result = mysql_query('SELECT pkJOURNAL_ID, WORK_DATE, TITLE, CONTENT FROM v1_JOURNAL WHERE MONTH(WORK_DATE) = ' . $_GET['MONTH'] . ' AND YEAR(WORK_DATE) = ' . $_GET['YEAR'] . ' ORDER BY WORK_DATE DESC') or die('query 1 failed.');
else
{
$result = mysql_query('SELECT DISTINCT MONTH(WORK_DATE), YEAR(WORK_DATE) FROM v1_JOURNAL ORDER BY YEAR(WORK_DATE) DESC, MONTH(WORK_DATE) DESC') or die('query 2 failed.');
while($row = mysql_fetch_array($result))
print '
' . $row[0] . '/' . $row[1] . ' archives';
print '
';
}
$strLastDate = '';
while($row = mysql_fetch_array($result))
{
if ($strLastDate != date('m/d/Y', strtotime($row['WORK_DATE'])))
print '
' . date('m/d/Y', strtotime($row['WORK_DATE'])) . '' . "\r\n";
$strLastDate = date('m/d/Y', strtotime($row['WORK_DATE']));
?>
}
if (isset($_GET['MONTH']))
print '
Back to Listing';
require('inc_footer.php');
?>