SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `znacka_nocs` <> "") AND skladem>3 order by znacka_nocs

$sql_shop->num_rows($res)11

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

SELECT distinct(li) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `li` <> "") AND skladem>3 order by li

$sql_shop->num_rows($res)2

1 row fetched

1 row fetched

SELECT distinct(si) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `si` <> "") AND skladem>3 order by si

$sql_shop->num_rows($res)2

1 row fetched

1 row fetched

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by valivy_odpor2

$valivy_odpor_select <option value="">---</option><option value="" ></option>

strlen 56

SELECT distinct(RF) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by RF

$sql_shop->num_rows($res)2

1 row fetched

1 row fetched

$val_od_db_vals_arr Array ( [0] => Array ( [RF] => ) [1] => Array ( [RF] => XL ) )

count = 2

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `valivy_odpor2` <> "") AND skladem>3 order by valivy_odpor2

$sql_shop->num_rows($res)0

SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2

SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `prilnavost_na_mokru2` <> "") AND skladem>3 order by prilnavost_na_mokru2

$sql_shop->num_rows($res)0

SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and `hlucnost2` <= "67" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by hlucnost2

SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="dunlop" and `si`="V" and `valivy_odpor2` <= "E" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `hlucnost2` <> "") AND skladem>3 order by hlucnost2

$sql_shop->num_rows($res)2

1 row fetched

1 row fetched