\n"; $query = "SELECT id,title FROM journals"; $result = $db->sql_query($query); while( $row = $db->sql_fetchrow($result) ){ $journals[$row[0]] = $row[1]; } $query = "SELECT contrib_num,authors,journal_id,pub_title,title FROM papers WHERE status<>'Published' AND contact_email IS NULL ORDER BY authors,title"; //echo $query; $result = $db->sql_query($query); echo "\n\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n\n"; while( $row = $db->sql_fetchrow($result) ){ echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; } echo "

#	Authors	Title	Journal	Publication Title
" . $row['contrib_num'] . "	" . $row['authors'] . "	" . $row['title'] . "	" . $journals[$row['journal_id']] . "	" . $row['pub_title'] . "

\n"; ?>