0) { for ($i=0;$i"; $db = @mysql_connect('localhost', 'genome', 't7805r*'); if (!$db) { print mysql_error(); } $databasename = "Genotyping"; if (!@mysql_select_db($databasename, $db)) { $str=mysql_error(); print $str; } ?> Influenza A Virus Genotype Project - Detail Genome Database
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "\n"; } } else { $genotype = $_GET['genotype']; $query1 = "select * from GenomeTable where genotype='$genotype'"; if ($_GET['animal']) { $query1=$query1." and host='".$_GET['animal']."'"; } $q = @mysql_query($query1); $evenrowcolor = "#f0f8ff"; $oddrowcolor = "#FFFFFF"; $NumRow = 0; while($line = mysql_fetch_array($q, MYSQL_ASSOC)) { if (($NumRow % 2) == 0) { $RowColor = $evenrowcolor; } else { $RowColor = $oddrowcolor; } $NumRow++; $pb2 = $line['PB2']; $pb1 = $line['PB1']; $pa = $line['PA']; $ha = $line['HA']; $np = $line['NP']; $na = $line['NA']; $mp = $line['MP']; $ns = $line['NS']; $x += 1; $genotype = $line['genotype']; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "\n"; } } #print $query."
"; print "
Genome IDStrainGenotypePB2PB1PAHANPNAMPNSLocationHostSerotypeYear
".$line['genomeID']." ".$line['strain']." ".$genotype." ".$pb2." ".$pb1." ".$pa." ".$ha." ".$np." ".$na." ".$mp." ".$ns." ".$line['location']." ".$line['host']." ".$line['serotype']." ".$line['year']; print "
".$line['genomeID']." ".$line['strain']." ".$genotype." ".$pb2." ".$pb1." "; print "".$pa." "; print "".$ha." ".$np.""; print " ".$na." ".$mp.""; print " ".$ns.""; print " ".$line['location']." ".$line['host']." ".$line['serotype']." ".$line['year']; print "
"; ?>