// 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 " |
Monitor holders
- Ergonomic products [8]
- Holders [27]
- Holders under the PC [2]
- Keyboard holder under the table [3]
- Stands [15]
- Stands for headsets [4]
- Tiltable tables [2]
- TV holders [2]
another products Holders and stands
Manufacturer
- ULTRADESK [5]
Color
- black [10]
- grey [3]
- white [1]
Ergonomic
- yes [13]
Fatening
- clamp [1]
- clamp or die [1]
- freestanding [2]
- table clamp and bushing [10]
Load
- 2-9KG [5]
- 3-12KG [1]
- 5KG [1]
- 9 kg [2]
- 10KG [3]
- 16KG [1]
- 20KG [1]
Monitor size
- 17"-30" [8]
- 17"-32" [4]
- 17"-36" [1]
- 27" [1]
Name
- Adjustable holder [14]
Pro
- for 2 monitors [5]
- for 2 Platinum monitors [1]
- for 3 monitors [1]
- for monitor [7]
Standard VESA
- 75x75/100x100 [14]