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