<HTML>
<TITLE>Select by category</TITLE>

<!

includeFile("../../include/right2.html");

echo("<CENTER>\n<TABLE WIDTH=40 CELSPACING=0 BORDER=0>\n");

echo("<TR><TD BGcolor=#31639c><CENTER><FONT FACE=\"Arial, Helvetica\" SIZE=0><A HREF=\"letter.msql\" TARGET=\"Fr5\">ABC</A></CENTER></TD></TR>\n");
echo("<TR><TD BGcolor=#31639c><CENTER><FONT FACE=\"Arial, Helvetica\" SIZE=0><A HREF=\"contacts.msql?&srch=\" TARGET=\"Fr3\">all</A></CENTER></TD></TR>\n");

        $sock = msqlConnect("localhost");
        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,"contacts") < 0) {
                printf("<BR><BR><BR><CENTER><TABLE><TR><TD><B><FONT SIZE=3>%s</FONT></TD></TR></TABLE>\n", $ERRMSG);
                fatal(""); 
            }

   if (msqlQuery($sock, "select nmbr, code from category order by nmbr")<0) {
      printf("<BR><BR><BR><CENTER><TABLE><TR><TD><B><FONT SIZE=3>%s</FONT></TD></TR></TABLE>\n", $ERRMSG);
      fatal("");
      } 

   $res=msqlStoreResult();
   $row=msqlFetchRow($res);

if (#$row > 0) {
   while(#$row > 0) {
      if ((int)$row[0] != 1) {
         printf("<TR><TD BGcolor=#31639c><CENTER><FONT FACE=\"Arial, Helvetica\" SIZE=0><A HREF=\"category.msql?&srch=%s\" TARGET=\"Fr3\">%s</A></CENTER></TD></TR>\n", $row[0], $row[1]);
         }
      $row=msqlFetchRow($res);    
   }
   msqlFreeResult($res);
}
>

</TABLE>
