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 ''; $img_form = $HTTP_SESSION_VARS['kat_filt_vyrobce'] == '' ? 'f1' : 'f0'; echo ''; echo ''; echo ''; // prehled vyrobcu echo ''; $sloupec = 1; @$sql = mysql_query($select); while ($row = mysql_fetch_Object($sql)){ $img_form = $HTTP_SESSION_VARS['kat_filt_vyrobce'] == $row->id_vyr ? 'f1' : 'f0'; echo ''; echo ''; if ($sloupec == 3) echo ""; $sloupec += 1; $sloupec = $sloupec == 4 ? 1 : $sloupec ; } if ($sloupec == 3) echo ""; if ($sloupec == 2) echo ""; echo ""; echo "
'; echo ''; echo ''; echo ''; echo wrd('kat_filt_vsichnivyr','Vsichni vyrobci').'    
'; echo ''; echo ''; echo ''; echo $row->popis_lg.' ('.$row->id_vyr.')   
  
"; // end - zobrazeni formulare filtru ?>

Loudspeakers

another products Multimedia

Filter

Manufacturer

  • Defender [28]
  • Genius [38]
  • HP [7]
  • Logitech [8]
  • Logo [2]
  • Marvo [7]
  • SWISSTEN [3]
  • YZSY [5]

Bluetooth

  • no [1]
  • yes [29]

Color

  • black [65]
  • black and blue [2]
  • black and grey [2]
  • black and red [2]
  • black-green [1]
  • black-orange [2]
  • blue [3]
  • brown [7]
  • brown and black [7]
  • green [1]
  • grey [1]
  • red [1]
  • silver [1]
  • white [3]
another

connector

  • Bluetooth [2]
  • RCA vstup, Bluetooth 5.0 [1]
  • USB/Bluetooth [1]
  • 3,5 mm jack [12]
  • 3,5 mm jack (USB) [19]
  • 3,5 mm jack (USB)+ AUX [1]
  • 3,5 mm jack/ bluetooth [6]

Damaged packaging

  • A-D [4]
  • B [4]

Portable

  • no [54]
  • yes [38]

Soundbar

  • yes [6]

Tape type

  • 1.0 [10]
  • 1.1 [1]
  • 2.0 [60]
  • 2.1 [18]
  • 5.1 [5]

Volume control

  • control panel [5]
  • remote control [6]
  • volume control [83]

Wattage [W]

  • 0-10 [63]
  • 0-45 [2]
  • 11-50 [22]
  • 51-100 [5]
  • 101 a více [6]