| |
 |
$title_short[$i]
";
IF ($reference_id != "" and $reference_id != 0) :
$temp_query = "SELECT * FROM $articles_table WHERE (preprint_id IN ($reference_id))";
$temp_result = MYSQL_QUERY($temp_query);
$number_of_refs = MYSQL_NUMROWS($temp_result);
$j = 0;
$reference[$i] = " (";
WHILE ($j < $number_of_refs) :
$authors = mysql_result($temp_result,$j,"author");
$preprint_id = mysql_result($temp_result,$j,"preprint_id");
$date_submission = mysql_result($temp_result,$j,"date_submission");
$date_acceptance = mysql_result($temp_result,$j,"date_acceptance");
$date_publication = mysql_result($temp_result,$j,"date_publication");
IF ($date_publication != "0000-00-00") :
$status = ", ";
$status .= substr ($date_publication, 0, 4);
$request_status = "Published";
$date = $date_publication;
ELSEIF ($date_acceptance != "0000-00-00") :
$status = ", in press";
$request_status = "Accepted";
$date = $date_acceptance;
ELSEIF ($date_submission != "0000-00-00") :
$status = ", submitted";
$request_status = "Submitted";
$date = $date_submission;
ELSE :
$status = ", in prep";
$request_status = "In Prep";
$date = "" ;
ENDIF;
IF ($j > 0) :
$reference[$i] .= "; ";
ENDIF;
$reference[$i] .= "";
$reference[$i] .= $authors;
$reference[$i] .= $status;
$reference[$i] .= "";
$j++;
ENDWHILE;
$reference[$i] .= ")";
ENDIF;
$i++;
ENDWHILE;
?>
|
|
![](\"spacer.gif\"){kind=spacer}
![](\"top.gif\")
