| |
 |
$result = MYSQL_QUERY($query);
/* How many of these users are there? */
$number = MYSQL_NUMROWS($result);
/* Print these results to the screen in a nice format */
$i = 0;
WHILE ($i < $number) :
$project_id[$i] = mysql_result($result,$i,"project_id");
$title_short[$i] = mysql_result($result,$i,"title_short");
$title_full[$i] = mysql_result($result,$i,"title_full");
$body_full[$i] = mysql_result($result,$i,"body_full");
$link1[$i] = mysql_result($result,$i,"link1");
$link1_title[$i] = mysql_result($result,$i,"link1_title");
$link2[$i] = mysql_result($result,$i,"link2");
$link2_title[$i] = mysql_result($result,$i,"link2_title");
$reference_id = mysql_result($result,$i,"reference_id");
PRINT "$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;
?>
|
|