// vyber filtru vyrobce
//***********************************************
$f_vyr = $HTTP_SESSION_VARS['kat_filt_vyrobce'];
$HTTP_SESSION_VARS['kat_filt_vyrobce'] = '';
include "./shop/filtr.php";
$HTTP_SESSION_VARS['kat_filt_vyrobce'] = $f_vyr;
//rozklad $kat na jednotlive casti
$strom0=0+SubStr($strom,1,4);
$strom1=0+SubStr($strom,5,2);
$strom2=0+SubStr($strom,7,2);
if (auth('00001111')) $viz = 'katalog.viz=1 and'; else $viz = '';
if ($strom2 > 0) $select = "SELECT vyrobci.id_vyr,vyrobci.popis_lg FROM katalog,vyrobci WHERE $viz katalog.id_strom = $strom $filtr and katalog.id_vyr=vyrobci.id_vyr GROUP BY vyrobci.id_vyr ORDER BY vyrobci.popis_lg";
elseif ($strom1 > 0) $select = "SELECT vyrobci.id_vyr,vyrobci.popis_lg FROM katalog,vyrobci WHERE $viz katalog.strom0 = $strom0 and katalog.strom1 = $strom1 $filtr and katalog.id_vyr=vyrobci.id_vyr GROUP BY vyrobci.id_vyr ORDER BY vyrobci.popis_lg";
elseif ($strom0 > 0) $select = "SELECT vyrobci.id_vyr,vyrobci.popis_lg FROM katalog,vyrobci WHERE $viz katalog.strom0 = $strom0 $filtr and katalog.id_vyr=vyrobci.id_vyr GROUP BY vyrobci.id_vyr ORDER BY vyrobci.popis_lg";
else $select = "SELECT vyrobci.id_vyr,vyrobci.popis_lg FROM katalog,vyrobci WHERE $viz katalog.strom0 > 0 $filtr and katalog.id_vyr=vyrobci.id_vyr GROUP BY vyrobci.id_vyr ORDER BY vyrobci.popis_lg";
//$href = 'strom='.$strom;
// seznam vyrobcu
echo '';
// vsichni vyrobci
echo '
";
// end - zobrazeni formulare filtru
?>
'; echo ''; echo ' | '; echo ''; echo ''; echo wrd('kat_filt_vsichnivyr','Vsichni vyrobci').' | '; echo '||||
'; echo ''; echo ' | '; echo ''; echo ''; echo $row->popis_lg.' ('.$row->id_vyr.') | '; if ($sloupec == 3) echo "||||
"; if ($sloupec == 2) echo " | "; echo " |
Papers, foils, cards [1206]
Manufacturer
- Avery Zweckform [185]
- Badgy [2]
- Brother [50]
- Canon [256]
- Color copy [13]
- Coloraction [49]
- Dymo [45]
- Epson [135]
- G&G [3]
- HP [237]
- Image [4]
- Kodak [56]
- Logo [78]
- Lyreco [1]
- MMnexo [1]
- Neutralle [52]
- OKI [4]
- Qilive [1]
- Rayfilm [1]
- Selecline [2]
- UPrint [3]
- Xerox [24]