\n";
$query = "SELECT * FROM papers WHERE status<>'Published' AND contact_email<>'' ORDER BY authors,title";
//echo $query;
$mes = 'Hello,
Our records indicate that you have previously requested and received a
US GLOBEC publication contribution number, and have not since updated
the status of your paper. At the bottom of this message, you will find
a copy of the information we have on file. Please take a moment to
update the information as needed. The link to use for this purpose is
given below.
Finally, if the article in question was never published, please let us
know by replying to this email.
Thank you
US GLOBEC National Office
';
$result = $db->sql_query($query);
$row = $db->sql_fetchrow($result);
$mes .= show_paper($row);
$mes .= '
http://www.usglobec.org/paper_request.php?ind=' . $row['contrib_num'] . '&act=upd
';
//mail('robertson@marine.rutgers.edu','Please help us update the US GLOBEC publications database',$mes,'From: robertson@marine.rutgers.edu');
echo preg_replace('/\n/','
',$mes);
?>