<TITLE>Leptospira Classification</TITLE>

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

<!

/*- ---------------------------------------------------------------------- -*/
/*- 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("This program can not be called without parameters.\n");
   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);

while (#$data>0) {
echo("$data[3]\n");
$data=msqlFetchRow($results);
}

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

msqlClose($sock);

>
