<?php
$filtr_kat = $_GET['filtr_kat'];
$filtr_pr = $_GET['filtr_pr'];
$filtr_sr = $_GET['filtr_sr'];
$filtr_typ = $_GET['filtr_typ'];
$filtr_cena = $_GET['filtr_cena'];


if (preg_match("/[^(\w)|(\x7F-\xFF)|(\s)]/",$filtr_kat)) {
	echo "invalid";
	
}if (preg_match("/[^(\w)|(\x7F-\xFF)|(\s)]/",$filtr_pr)) {
	echo "invalid";
	
}if (preg_match("/[^(\w)|(\x7F-\xFF)|(\s)]/",$filtr_sr)) {
	echo "invalid";
	
}if (preg_match("/[^(\w)|(\x7F-\xFF)|(\s)]/",$filtr_typ)) {
	echo "invalid";
	
}if (preg_match("/[^(\w)|(\x7F-\xFF)|(\s)]/",$filtr_cena)) {
	echo "invalid";
	
}


 $PZS = 5; 
 $str = 1;
 $message = "Error"; 
 
 if (isset($_GET['str']) &&
     $_GET['str']> 0) { 
    $str = $_GET['str'];
 }
 
 
include_once("connectdb.php");

 $resultCount = mysql_query("SELECT COUNT(0) FROM site left join reklama 
                ON reklama.stranka=site.id 
                      AND reklama.`typreklamy` LIKE '%$filtr_typ%'   
                      AND reklama.`aktiv`='0' 
            WHERE site.`kategorie` LIKE '%$filtr_kat%' 
                         AND site.`pagerank` LIKE '%$filtr_pr%' 
                         AND site.`srank` LIKE '%$filtr_sr%'
                         AND site.`aktiv`='0'
                         ");

 $pocetZaznamu = mysql_result($resultCount, 0);
 
 // SQL funkce LIMIT(START, COUNTS)

 $start = ($str - 1) * $PZS;
 

 $pocet = (($pocetZaznamu % $PZS)> 0) ? (int)($pocetZaznamu / $PZS) + 1  : $pocetZaznamu / $PZS;


 for ($i = 1; $i <= $pocet; $i++) {
    if ($i != $str) {
        echo "<td class='upmenu2' align='center' width='18' height='15' bgcolor='#D3D3D3'><a href='?str=".$i."&filtr_kat=".$filtr_kat."&filtr_pr=".$filtr_pr."&filtr_sr=".$filtr_sr."&filtr_typ=".$filtr_typ."&filtr_cena=".$filtr_cena."'>".$i."</a></td>";
    } else { // aktuбlnн strana
        echo "<td class='upmenu2' align='center' width='18' height='15' bgcolor='black'><a href='?str=".$i."&filtr_kat=".$filtr_kat."&filtr_pr=".$filtr_pr."&filtr_sr=".$filtr_sr."&filtr_typ=".$filtr_typ."&filtr_cena=".$filtr_cena."'><b>".$i."</b></a></td>";
    }
 }

if ($filtr_cena !="asc" && $filtr_cena !="desc") {
} else {
$result = mysql_query("SELECT * FROM site left join reklama 
                ON reklama.stranka=site.id 
                      AND reklama.`typreklamy` LIKE '%$filtr_typ%'   
                      AND reklama.`aktiv`='0' 
            WHERE site.`kategorie` LIKE '%$filtr_kat%' 
                         AND site.`pagerank` LIKE '%$filtr_pr%' 
                         AND site.`srank` LIKE '%$filtr_sr%'
                         AND site.`aktiv`='0'
                         ORDER BY vasecena $filtr_cena LIMIT ".$start.",".$PZS) or die(mysql_error());
  while ($row = mysql_fetch_array($result)) {

Спустя 21 час, 14 минут (3.10.2010 - 15:36) westgiggs написал(а):

спасибо помогло