Possible Ontologies:
";
echo "";
echo "Anatomy
\n";
echo "";
echo "Growth
\n";
echo "\n";
echo "\n";
echo "\n";
echo "";
echo "
\n";
$username="inparanoid-read-user";
$password="inparanoid-read-user_pw";
$database="inparanoid_data";
$url="floret.cgrb.oregonstate.edu:3306";
$info = explode(",",$_POST['param']);
$connection=mysql_connect($url,$username,$password);
mysql_select_db($database);
$query="select species, gene from super_clust where super_id=" . $info[0] . " order by species";
$results=mysql_query($query);
$numRows = mysql_num_rows($results);
if(!$results) {
echo "DB Error, could not list tables";
}
echo "Cluster " . $info[1] . " contains " . $numRows . " genes:
";
$row = mysql_fetch_row($results);
while($row != null) {
$str=$row[1] . " (" . $row[0] . ")";
echo "" . $str . "
";
$row = mysql_fetch_row($results);
}
$query="select gene from super_clust where super_id=" . $info[0] . " order by gene";
$results=mysql_query($query);
$i = 0;
$tempgenes = array();
$row = mysql_fetch_row($results);
while($row != null) {
$tempgenes[$i] = $row[0];
$row = mysql_fetch_row($results);
$i ++;
}
$genes = implode(",",$tempgenes);
mysql_close($connection);
} else if($_POST["type"] == "species") {
$username="inparanoid-read-user";
$password="inparanoid-read-user_pw";
$database="inparanoid_data";
$url="floret.cgrb.oregonstate.edu:3306";
$input = explode(",",$_POST['param']);
$orderLogic = $_POST['orderBy'];
$species = $input[0];
$clusterCount = sizeof($input)-1;
// creating logic statements
$clusters = "super_id=";
for($i=0; $i < $clusterCount; $i++) {
$clusters = $clusters . $input[$i+1];
if(($i+1) < (sizeof($input)-1)) {
$clusters = $clusters . " or super_id=";
}
}
echo "