" target="_blank"> |
Molecular Publications |
|
|
|
Journal_Display; } }
if($Journal_Display) { $Paper_Cache .= " ".$Journal_Display; }
if($Journal_Display == "") { $Paper_Cache .= " IN: ".$formBook." ".$formPublisher; }
if($formVolume) { $Paper_Cache .= " ".$formVolume.": "; }
if($formPages) { $Paper_Cache .= " ".$formPages."."; }
$formYear = addslashes($formYear);
$formTitle = addslashes($formTitle);
$formVolume = addslashes($formVolume);
$formPages = addslashes($formPages);
$formBook = addslashes($formBook);
$formPublisher = addslashes($formPublisher);
$formLink = addslashes($formLink);
$Paper_Cache = addslashes ($Paper_Cache);
$sql3 = "INSERT INTO publications (Editors, Year, Title, FK_Journal, Volume, Pages, Book, Publisher, Link, Paper_Cache, Created_Who) VALUES " .
"('$formEds','$formYear','$formTitle','$formJournal','$formVolume','$formPages','$formBook','$formPublisher','$formLink','$Paper_Cache','$log')";
$result3 = mysql_query($sql3);
$IDPublication = mysql_insert_id();
#######################################Error 3###############################################################
if(!$result3)
{ $msg = $sql3."\n";
$msg .= "####Error 3####";
if($debug == '1') echo $msg;
trigger_error($msg, E_USER_ERROR); }
#############################################################################################################
for($i=0; $i<$autcount; $i++)
{
if($i!=0) $sql .= ",";
$sql .= "($IDPublication, $IDAuthor[$i])";
$sql5 = "INSERT INTO publications_authors (FK_Publications, FK_Author, Created_Who) " .
"VALUES ('$IDPublication','$IDAuthor[$i]','$log')";
$result5 = mysql_query($sql5);
#######################################Error 5###############################################################
if(!$result5)
{ $msg = $sql5."\n";
$msg .= "####Error 5####";
if($debug == '1') echo $msg;
trigger_error($msg, E_USER_ERROR); }
#############################################################################################################
}
if($result3)
{echo "Data have been saved! Paper: ".$Paper_Cache;}
}
?>
|
|