if ($display_side_menu) echo"
Loading Menu... | |
| \n";
else {echo "\n";include("text_menu.html");echo" | \n";}
?>
|
$layerID = array();
$layer_name = array();
$Tnum = array();
$accession = array();
$numsub = array();
$aveD = array();
$maxD = array();
$sub_name = array();
$pdb_list = array();
$results = mysql_query("SELECT max(Tnum), layers, PDBID, name, family, spgroup, res, lattice, pid, genus, cite, related
from virus_info, layers WHERE virus_info.vipPDB='$vipPDB' and virus_info.vipPDB=layers.vipPDB GROUP BY virus_info.vipPDB");
$numrows=mysql_num_rows($results);
if ($numrows != 0){
$myrow = mysql_fetch_array($results);
$maxTnum=$myrow["max(Tnum)"];
$name = $myrow["name"];
$family = $myrow["family"];
$spgroup = $myrow["spgroup"];
$res = $myrow["res"];
if (!$res) $res='MODEL';
$lattice = $myrow["lattice"];
$pid = $myrow["pid"];
$genus = $myrow["genus"];
$cite = $myrow["cite"];
$related = $myrow["related"];
$layers = $myrow["layers"];
$PDBID = strtoupper($myrow["PDBID"]);
$vipPDBup = strtoupper($vipPDB);
$results = mysql_query("SELECT layerID, layer_name, Tnum, accession, numsub, aveD, maxD, subunit_name from layers
WHERE vipPDB='$vipPDB' order by layer_name");
while ($myrow = mysql_fetch_array($results)) {
array_push($layerID, $myrow["layerID"]);
array_push($layer_name, $myrow["layer_name"]);
array_push($Tnum, $myrow["Tnum"]);
array_push($accession, strtoupper($myrow["accession"]));
array_push($numsub, $myrow["numsub"]);
array_push($aveD, $myrow["aveD"]);
array_push($maxD, $myrow["maxD"]);
array_push($sub_name, $myrow["subunit_name"]);
}
//get list of PDB files for the BACK and NEXT links at top of page
$tnumlist = $Tnum[0];
if ($tnumlist == '7l' || $tnumlist == '7d') $tnumlist = "7d' OR Tnum='7l";
elseif ($tnumlist == '1(2)') $tnumlist = 13;
elseif (preg_match("/pT/i", $tnumlist)) $tnumlist = preg_replace("/(pT\d+)/", "$1", $tnumlist);
$results = mysql_query("SELECT virus_info.vipPDB from virus_info, layers
WHERE virus_info.vipPDB = layers.vipPDB AND (Tnum = '$tnumlist')");
while ($myrow=mysql_fetch_array($results)){
array_push($pdb_list, $myrow["vipPDB"]);
}
}
else $vipPDB='';
?>
input virus not found!
Select a virus from the Name Index or
Try searching for your entry
|