='".$_GET['datum_od_r']."-".$_GET['datum_od_m']."-01'"; } else { $podminka = " WHERE nebezpecny_vyrobek='A' AND zobrazit='A' AND datum>='".$_GET['datum_od_r']."-".$_GET['datum_od_m']."-01' AND kategorie like '".$vybrano_kategorie."'"; } if($klicove_slovo<>"") { $podminka .=" AND klicove_slovo like '%".$klicove_slovo."%'"; } ?> <? echo $nadpis; ?>

Krajská hygienická stanice Moravskoslezského kraje se sídlem v Ostravě
























































Filtr:

"; $sSQL = "SELECT MIN(datum) as datum_min, MAX(datum) as datum_max FROM 01_uredni_deska_nv;"; $rs = mysql_query($sSQL) or die (mysql_error()); $row = mysql_fetch_array($rs); $datum_min="2013-01-01"; $table="01_uredni_deska_nv"; $field = "kategorie"; // The field that contains the ENUM $result=mysql_query('show columns from '.$table.';'); while($tuple=mysql_fetch_assoc($result)) { if($tuple['Field'] == $field) { $types=$tuple['Type']; $beginStr=strpos($types,"(")+1; $endStr=strpos($types,")"); $types=substr($types,$beginStr,$endStr-$beginStr); $types=str_replace("'","",$types); $types=split(',',$types); if($sorted) sort($types); break; } } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
kategorieklíčové slovodatum od: 
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; //echo ""; /* echo "
"; echo "kategorie=".$kategorie; echo "
"; echo "vybraná kategorie=".$vybrano_kategorie; echo "
"; echo "podmínka=".$podminka; echo "
"; echo "adr1=".$_SERVER['PHP_SELF']; echo "
"; echo "adr2=".basename($_SERVER['REQUEST_URI']); */ //echo $podminka; echo "
"; ?> "; print "
"; print ""; print "
"; print "
"; if ($row["datum"]<>'0000-00-00') { print "
".date("d.m.Y", strtotime($row["datum"]))."
"; } print "
"; print "".$row['nadpis'].""; print "
"; print "
"; print ""; endwhile; mysql_free_result($rs); $query1 = "SELECT COUNT(id) AS numrows1 FROM 01_uredni_deska_nv $podminka"; $result1 = mysql_query($query1) or die('Error, query failed1'); $row1 = mysql_fetch_array($result1, MYSQL_ASSOC); $query = "SELECT COUNT(id) AS numrows FROM 01_uredni_deska_nv $podminka;"; $result = mysql_query($query) or die('Error, query failed2'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row1['numrows1']; $maxPage = ceil($numrows/$rowsPerPage); if($maxPage==0) $maxPage=1; $cely_odkaz=basename($_SERVER['REQUEST_URI']); /* echo "
"; if($_GET['page']) { echo "page: ".$page; } else { echo "page: nic"; } echo "
"; echo "
"; if($_GET['odeslat']) { echo "odeslat: ".$odeslat; } else { echo "odeslat: nic"; } echo "
"; echo "
"; if($_GET['StranaForm']) { echo "StranaForm: ".$StranaForm; } else { echo "StranaForm: nic"; } echo "
"; */ if ($pageNum > 1) { $page = $pageNum-1; if (empty($_GET['page']) AND empty($_GET['odeslat']) AND empty($_GET['StranaForm'])) { $prev = " [Předchozí] "; $first = " [První] "; } else { $prev = " [Předchozí] "; $first = " [První] "; } } else { $prev = ' '; // we're on page one, don't print previous link $first = ' '; // nor the first page link } if ($pageNum < $maxPage) { $page = $pageNum + 1; if (empty($_GET['page']) AND empty($_GET['odeslat']) AND empty($_GET['StranaForm'])) { $next = " [Další] "; $last = " [Poslední] "; } else { $next = " [Další] "; $last = " [Poslední] "; } } else { $next = ' '; // we're on the last page, don't print next link $last = ' '; // nor the last page link } echo "
"; echo "".$first . $prev ." Strana $pageNum z $maxPage " . $next . $last.""; ?>     " style="display:inline"> */ ?>