PubMed Details
5 and locusid1 not REGEXP '^MI'union SELECT distinct locoracc as locusid1,pubmedID, figurename, figureortable from reqfundetails where pubmedID = '$searchid' and length(locoracc)>5 union SELECT distinct locusid1,pubmedID,figurename,figureortable from reqintdetails where pubmedID = '$searchid' and length(locusid1)>5 order by locusid1"); } if ( $searchtype =='PO') { $sql22=mysql_query("SELECT distinct x.locusid1 as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqfigdetails x, reqfigsubpo y where y.poid = '$searchid' and x.connectID=y.connectID and x.locusid1 not REGEXP '^MI' union SELECT distinct x.locoracc as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqfundetails x, reqfunsubpo y where y.poid = '$searchid' and x.pubmedID=y.pubmedID and x.figurename=y.figurename and x.figureortable=y.figureortable and x.goid=y.goid order by locusid1,pubmedID,figurename"); } if ( $searchtype =='EO') { $sql22=mysql_query("SELECT distinct x.locusid1 as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqfigdetails x, reqfigsubeo y where y.eoid = '$searchid' and x.connectID=y.connectID and x.locusid1 not REGEXP '^MI' union SELECT distinct x.locoracc as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqfundetails x, reqfunsubeo y where y.eoid = '$searchid' and x.pubmedID=y.pubmedID and x.figurename=y.figurename and x.figureortable=y.figureortable and x.goid=y.goid union SELECT distinct x.locusid1 as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqintdetails x, reqintsubeo y where y.eoid = '$searchid' and x.pubmedID=y.pubmedID and x.figurename=y.figurename and x.figureortable=y.figureortable order by locusid1,pubmedID,figurename"); } if ( $searchtype =='TO') { $sql22=mysql_query("SELECT distinct x.locusid1 as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqfigdetails x, reqfigsubto y where y.toid = '$searchid' and x.connectID=y.connectID and x.locusid1 not REGEXP '^MI' order by locusid1,pubmedID,figurename"); } if ( $searchtype =='GO') { $sql22=mysql_query("SELECT distinct x.locoracc as locusid1, x.pubmedID as pubmedID, x.figurename as figurename, x.figureortable from reqfundetails x where x.goid = '$searchid' union SELECT distinct x.locusid1 as locusid1 ,x.pubmedID as pubmedID,x.figurename as figurename,x.figureortable from reqintdetails x, reqintsubgo y where y.goid = '$searchid' and x.pubmedID=y.pubmedID and x.figurename=y.figurename and x.figureortable=y.figureortable order by locusid1,pubmedID,figurename"); } $num_rows22=mysql_num_rows($sql22); ?>
PubMed Id : details
:] Method : details PO Id : details EO Id : details TO Id : details GO Id : details
0) { $description =mysql_result($sqldesc, 0, 'description'); } $methoddesc=mysql_query("select figuremethod from reqfigmain where pubmedID='$pubmedid' and figurename='$figurename' and figureortable='$fort'; "); $num_rowsmethod = mysql_num_rows($methoddesc); if ($num_rowsmethod > 0) { $method =mysql_result($methoddesc, 0, 'figuremethod'); } else { $methoddesc=mysql_query("select figuremethod from reqfunmain where pubmedID='$pubmedid' and figurename='$figurename' and figureortable='$fort'; "); $num_rowsmethod = mysql_num_rows($methoddesc); if ($num_rowsmethod > 0) { $method =mysql_result($methoddesc, 0, 'figuremethod'); } else { $methoddesc=mysql_query("select figuremethod from reqintmain where pubmedID='$pubmedid' and figurename='$figurename' and figureortable='$fort'; "); $num_rowsmethod = mysql_num_rows($methoddesc); if ($num_rowsmethod > 0) { $method =mysql_result($methoddesc, 0, 'figuremethod'); } } } ?>
S.No Accession Id Description PubMed Id Figure number Figure Method

Department of Plant Molecular Biology, University of Delhi South Campus, New Delhi-110021, India