<TITLE>Leptospira Classification</TITLE>

<!
includeFile("body.html");
includeFile("../text&html/head.html");
>

<CENTER>
<IMG SRC="../pictures/subhead-class.gif">
</CENTER>

<!

/*- ---------------------------------------------------------------------- -*/
/*- Open connection to database and SELECT data from tables		   -*/
/*- ---------------------------------------------------------------------- -*/
$sock = msqlConnect();
if ($sock < 0) {
   printf("<BR><BR><BR><CENTER><TABLE><TR><TD><B><FONT SIZE=3>%s</FONT></TD></TR></TABLE>\n", $ERRMSG);
   fatal("");
   }
if (msqlSelectDB($sock,"leptospira") < 0) {
   printf("<BR><BR><BR><CENTER><TABLE><TR><TD><B><FONT SIZE=3>%s</FONT></TD></TR></TABLE>\n", $ERRMSG);
   fatal("");
   }

if ($serovar=="") {
   echo("<BR><CENTER>This program can not be called without parameters.<BR><P>\n");
   includeFile("../text&html/to-top1.txt");
   exit(0);
   }
$srch="SELECT * FROM serovars WHERE serovar CLIKE '$serovar'";

/*- ---------------------------------------------------------------------- -*/
/*- Connected to mSQL server, now try to send SELECT query to database     -*/
/*- ---------------------------------------------------------------------- -*/
if (msqlQuery($sock, $srch)<0) {
   printf("<BR><BR><BR><CENTER><TABLE><TR><TD><B><FONT SIZE=3>%s</FONT></TD></TR></TABLE>\n", $ERRMSG);
   fatal("");
   } 

$results=msqlStoreResult();
$data=msqlFetchRow($results);

if (#$data>0) {

echo("<HR WIDTH=100%>\n");

echo("<TABLE><TR>\n");
echo("<TD>GENUS</TD><TD><FONT FACE=\"Arial, Helvetica\"><I>$data[1]<I></FONT></TD></TR>\n");
echo("<TD>SPECIES</TD><TD><FONT FACE=\"Arial, Helvetica\"><I>$data[2]</I></FONT></TD></TR>\n");
echo("<TD>SEROGROUP</TD><TD><FONT FACE=\"Arial, Helvetica\"><I>$data[3]</I></FONT></TD></TR>\n");
echo("<TD>SEROVAR</TD><TD><FONT FACE=\"Arial, Helvetica\"><B><I>$data[4]</I></B></FONT></TD></TR>\n");
echo("<TD>STRAIN</TD><TD><FONT FACE=\"Arial, Helvetica\"><I>$data[5]</I></FONT></TD></TR>\n");


echo("</TABLE>\n");

echo("<HR WIDTH=100%>\n");

} else {
   echo("Sorry, serovar that you are trying find, does not exist in our database.<BR>\n");
}


includeFile("../text&html/to-top1.txt");

msqlClose($sock);

>
