mysql_connect ("localhost", "web", "guest")
or die("Unable to connect to SQL server");
mysql_select_db("abbott2") or die("Unable to select database");
if ($display == null) {
$display = 'who';
}
?>

Welcome to the search page to the Abbott Letters database. You may
enter search terms in the box below to search for the letters that
meet your criteria, or you may select a letter from the listing at the
bottom of the page based on the selected criterion. You may also
search the Times Letters separately.
|
$tableslot = -1;
$dates = mysql_query("select id,$display from letters where id != 1 ORDER BY $display") or die ("Unable to retrieve letters");
while ($item = mysql_fetch_array($dates)) {
$tableslot = ($tableslot + 1) % 3;
if (substr(trim($item[$display]),0,50) != "") {
if ($tableslot == 0) { echo ""; } ?>
echo substr(trim($item[$display]),0,50); ?> echo " | ";
if ($tableslot == 2) { echo " "; }
}
}?>
|
virtual("../bottom.txt") ?>