<?
$pre    = '../';
include $pre . "common.php";

$query  = "SELECT * FROM papers ORDER BY contrib_num";
$result = $db->sql_query($query);

$fd = fopen('papers.txt', 'w');
while( $row = $db->sql_fetchrow($result) ){
   $out  = "CONTRIB #: " . $row['contrib_num'] . "\n";
   $out .= "STATUS: " . $row['status'] . "\n";
   $out .= "YEAR: " . $row['date'] . "\n";
   $out .= "AUTHORS: " . $row['authors'] . "\n";
   $out .= "TITLE: " . $row['title'] . "\n";
   $out .= "JOURNAL: " . $row['journal_title'] . "\n";
   $out .= "PUB/ISSUE TITLE: " . $row['pub_title'] . "\n";
   $out .= "DOI: " . $row['doi'] . "\n";
   $out .= "VOLUME: " . $row['volume'] . "\n";
   $out .= "PAGES: " . $row['pages'] . "\n";
   $out .= "LINK: " . $row['link'] . "\n\n";

   fwrite($fd, $out);
}
fclose($fd);
?>