Chronology of Saving the Mint

Project Goals
Proposed Layout 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 "

"; echo "Select a year "; while(list($key,$value)=each($yr_sel)) { echo "$value\n"; } echo "

\n"; echo ""; while(!$rs->EOF) { $t = $rs->fields["title_en"]; $d = $rs->fields["descr_en"]; $fd = fdate($rs->fields["date"], en); echo "\n"; $rs->nextRow(); } echo "

\n"; echo " "; echo $fd . " \n"; echo " " . htmlprep($t) . " \n"; echo " " . htmlprep($d) . "

\n"; ?>