From 07f6af5338a3bae486208aa5d320ce137d332172 Mon Sep 17 00:00:00 2001 From: miles Date: Mon, 25 Mar 2013 20:58:28 +0000 Subject: [PATCH] View Ontology Changes: -evidence count is now included in the returned mysql table; not yet included in the actual website svn path=/; revision=441 --- Personnel/miles/Web Page/viewOntology.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Personnel/miles/Web Page/viewOntology.php b/Personnel/miles/Web Page/viewOntology.php index fed4c22..8056cbb 100644 --- a/Personnel/miles/Web Page/viewOntology.php +++ b/Personnel/miles/Web Page/viewOntology.php @@ -57,7 +57,9 @@ for($i = 0; $i < sizeof($genes); $i++) { $logic = $logic . $toAdd; } -$query = "select full_name,term_id,concat(acc, \": \", name) from (select full_name,term_id from gene_product left join association on association.gene_product_id=gene_product.id " . $logic . " order by full_name,term_id) as temp left join term on term.id=term_id order by full_name,acc"; +$query = "select full_name,term_id,concat(acc, \": \", name),evnum from (select full_name,term_id,count(*) as evnum from gene_product left join association on association.gene_product_id=gene_product.id " . $logic . "group by full_name,term_id order by full_name,term_id) as temp left join term on term.id=term_id order by full_name,acc"; + +echo $query; $results=mysql_query($query); $t = 0; -- 2.34.1