Czech o-web katalog

   

ERROR\n"; Die("Zprávičky nebudou"); endif; $pocet = 0; $pocet1 = 0; if (StrLen(Trim($hledat))==0): $result = mysql("milan", "select * from okatalog where LOCATE('$kat', kategorie) and (priznak='*') order by nadpis"); $result1 = mysql("milan", "select * from okatalog where LOCATE('$kat', kategorie) and (priznak='1') order by nadpis"); $pocet1 = mysql_NumRows($result1); else: $result = mysql("milan", "select * from okatalog where LOCATE(UPPER('$hledat'),UPPER(nadpis)) or LOCATE(UPPER('$hledat'),UPPER(textces)) or LOCATE(UPPER('$hledat'),UPPER(textang)) or LOCATE(UPPER('$hledat'),UPPER(slova)) order by nadpis"); endif; if ((StrLen(Trim($hledat))<3) and (StrLen(Trim($kat))==0)) echo "Too short text for search.

"; else $pocet = mysql_NumRows($result); if ($pocet1>0): echo "   Top links:
"; $i = 0; while ($i<$pocet1): $stav=""; if (mysql_Result($result1, $i, 'podkategorie')=='m') $stav=" ! Web is not in service"; echo "   ".mysql_Result($result1, $i, 'nadpis').": ".mysql_Result($result1, $i, 'textang').$stav. "
"; $i++; endwhile; echo "


"; endif; if ($pocet==0) echo "No such item!"; $i = 0; while ($i<$pocet): $stav=""; if (mysql_Result($result, $i, 'podkategorie')=='m') $stav=" ! Web is not in service"; echo "   ".mysql_Result($result, $i, 'nadpis').": ".mysql_Result($result, $i, 'textang').$stav. "
"; $i++; endwhile; if ($kat=="C"): echo "
"; echo "   Calendar of Czech Orienteering Federation:
"; echo "   This week   "; echo "   Next   "; echo "   Past
"; $pocet = 0; $result = mysql("milan", "select * from okatalog where LOCATE('Y', kategorie) and (priznak='*') order by datzavod"); $pocet = mysql_NumRows($result); $i = 0; while ($i<$pocet): $stav=""; if (mysql_Result($result, $i, 'podkategorie')=='m') $stav=" ! Web je asi nefunkční"; echo "   ".mysql_Result($result, $i, 'nadpis').": " .SubStr(mysql_Result($result, $i, 'datzavod'),8,2).".".SubStr(mysql_Result($result, $i, 'datzavod'),5,2).".".Substr(mysql_Result($result, $i, 'datzavod'),0,4). " - ".mysql_Result($result, $i, 'textang').$stav. "
"; $i++; endwhile; endif; mysql_Close();?>


email: webmaster@orienteering.cz