7cab12e72257613d386b4dc49b1b64b324450995 max Tue Dec 8 15:04:48 2015 -0800 fixing malacards after update, refs #14417 diff --git src/hg/hgGene/malacards.c src/hg/hgGene/malacards.c index 995c144..d70acc0 100644 --- src/hg/hgGene/malacards.c +++ src/hg/hgGene/malacards.c @@ -36,31 +36,31 @@ char query[1024]; struct sqlResult *sr; char **row; char *itemName; sqlSafef(query, sizeof(query), "select k.geneSymbol from kgXref k, malacards m" " where k.kgId='%s' and k.geneSymbol = m.geneSymbol", geneId); itemName = sqlQuickString(conn, query); printf("<B>Malacards Gene Search: "); printf("<A HREF='http://www.malacards.org/search/eliteGene/%s' target=_blank>", itemName); printf("%s</B></A>\n", itemName); /* List diseases associated with the gene */ sqlSafef(query, sizeof(query), -"select maladySymbol, urlSuffix, mainName, round(score) from malacards where geneSymbol='%s' order by score desc", +"select maladySymbol, urlSuffix, mainName, round(geneScore) from malacards where isElite=1 and geneSymbol='%s' order by geneScore desc", itemName); sr = sqlMustGetResult(conn, query); row = sqlNextRow(sr); if (row != NULL) printf("<BR><B>Diseases sorted by score: </B>"); while (row != NULL) { char *maladySym = row[0]; char *mainName = row[2]; char *score = row[3]; printf("<A HREF='http://www.malacards.org/card/%s' target=_blank>%s</a> (%s)", maladySym, mainName, score); row = sqlNextRow(sr); if (row!=NULL)