<html>
<head>
<title>ANISEED - Find ascidian articles related to anatomy (Ciona intestinalis, Halocynthia roretzi)</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="description" content="This page lists ascidian articles describing the specification of a given cell fate. For more information, contact aniseed@ibdm.univ-mrs.fr">
<meta name="keywords" content="Ascidian articles, publication, literature, ascidian literature, Ciona gene, Ciona intestinalis, Halocynthia roretzi, ascidian database, ciona intestinalis database.">
<meta name = "robots" content = "index, follow, all">
<META HTTP-EQUIV="Content-Language" CONTENT="EN">
<style type="text/css">
</style>
</head>

<?
include ("connection.php");
include ("frames_header.php");


$devstage=$_POST["devstage"];
//print_r($devstage);

$fate=$_POST["fate"];
//print_r($fate);



$tfate=join("','",$fate);

$requete="

select * from \"ARTICLE\" where \"ARTICLE_ID\" in (
select distinct \"ARTICLE_ID\" from \"ARTICLE_FATE\" where \"FATE\" in ('$tfate')
)

";
$stmt=pg_query($c,$requete);
//print $requete."<br>";
/*
$NUM=pg_num_rows($stmt);
if ($NUM==1) print "<center><em><b>".$NUM." </b> article in the database is matching your query</center></em><br>";
else print "<center><em><b>$NUM </b> articles in the database are matching your query</center></em><br>";
*/

?>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center"><font color="#456898" size="2"><b>Title</b></font></td><td align="center"><font color="#456898" size="2"><b>Journal</b></font></td><td align="center"><font color="#456898" size="2"><b>Authors</b></font></td><td align="center"><font color="#456898" size="2"><b>Aniseed data</b></font></td><td align="center"><font color="#456898" size="2"><b>Pubmed</b></font></td></tr>
<?

$AFFICH=0;

while ($row=pg_fetch_array($stmt))
{

$article_id=$row["ARTICLE_ID"];
$pmid=$row["PUBMED_ID"];




/////////////// FILTER THE STATUS OF THE ARTICLE TO KNOW WETHER ITS PUBLIC CURATED, OR NOT (IS NOT CURATED IF ALL THE EXPERIMENTS
//// ASSOCIATED WITH ARE NOT CURATED

$requete0="select distinct \"CHECKED\" from \"IN_SITU\" where \"IN_SITU_ID\" in (
SELECT \"BIO_ID\" from \"REFERENCE\" where \"PUBMED_ID\"='$pmid')";
$stmt0=pg_query($c,$requete0);
$s="";
while ($row0=pg_fetch_array($stmt0)) $s.=$row0["CHECKED"];
//print $pmid." ".$row["CHECKED"]."<br>";
//print $pmid." ".$s."<br>";

if ($s=="n") continue;

$AFFICH++;








$title=$row["TITLE"];
$paper=$row["PAPER"];
$auteur=$row["AUTHORS"];
$comments=$row["COMMENTS"];
print "<tr>";

print "<td style=\"border-top:1px solid black;\" valign=\"center\"><font color=\"#656565\" size=\"-2\">$title</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$paper</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$auteur</font><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\">

<!--<a href=\"biblio.php?pmid=$pmid\"><img src=\"pictures/mini-aniseed.jpg\" border=\"0\"></a>-->

<a href=\"view-article.php?id=$article_id\"><img src=\"pictures/mini-aniseed.jpg\" border=\"0\"></a>

</td></td><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\"><a href=\"http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Retrieve&list_uids=$pmid&dopt=Abstract\"><font color=\"#000000\" size=\"-2\"><img src=\"pictures/mini-pubmed.jpg\" border=\"0\"></a></font></td>";



print "</tr>";




}


print "</table>";

if ($AFFICH==0) 
	{
	print "<br><br><center><strong>Aniseed database doesn't contain any articles matching with your query</strong></center><br><br>";
	include ("frames_footer.php");
	return;
	}





include ("frames_footer.php");
?>