Project Goals Proposed Layout
// Get list of years
$sql = 'select distinct DATE_FORMAT(date, "%Y") from news_item';
$rs = $db->execute($sql);
while(!$rs->EOF)
{
$yr_sel[] = $rs->fields[0];
$rs->nextRow();
}
rsort($yr_sel);
if (!$yr) $yr = $yr_sel[0];
$yr .= "%";
// Get news items
$sql = "SELECT * FROM news_item WHERE date LIKE '$yr' ORDER BY date DESC";
$rs = $db->execute($sql);
echo "\n";
echo "