'); $year=1900; while ($year < 2010) { $year++; $select= "SELECT * FROM `testTJG2` WHERE (date=$year)"; echo(' 1:'.$select); $result=@mysql_query($select) or die('The search on '.$year.' failed; please try again in a minute or contact the webmaster.'); echo(' 2:'.$result); $current = mysql_fetch_array($result); $title = $current["title"]; $date = $current["date"]; $description = $current["description"]; $desc = substr($description,0,80); $filename = $current["url"]; $firstnum = $filename{0} + 1; $firstbit = substr($filename, 0, 2); $firstchar = (string) $firstnum; echo(' '); } echo(' '.$filename.' '.$title.' : '.$date.' '.$desc.'...

'); ?>