\n"); //Lemezfelni kereso distinct Automarkak $lfelni_result = mysql_query("SELECT distinct AFLNI_CARTYPE from aflni ORDER BY AFLNI_CARTYPE ASC", $sql_con); while ($egy_sor = mysql_fetch_row($lfelni_result)) { foreach ($egy_sor as $ertek) { $lfelni_gyarto = $lfelni_gyarto . '\n"; } } //Abroncs kereso distinct parameterek $abroncs_result_gyarto = mysql_query("SELECT distinct GBRCS_TYPE from gbrcs ORDER BY GBRCS_TYPE ASC", $sql_con); while ($egy_sor = mysql_fetch_row($abroncs_result_gyarto)) { foreach ($egy_sor as $ertek) { $abroncs_gyarto = $abroncs_gyarto . '\n"; } } $abroncs_result_meret1 = mysql_query("SELECT distinct GBRCS_ITEMWIDTH from gbrcs WHERE GBRCS_ITEMWIDTH<>'0' AND GBRCS_ITEMWIDTH<>'' ORDER BY GBRCS_ITEMWIDTH ASC", $sql_con); while ($egy_sor = mysql_fetch_row($abroncs_result_meret1)) { foreach ($egy_sor as $ertek) { $abroncs_meret1 = $abroncs_meret1 . '\n"; } } $abroncs_result_meret2 = mysql_query("SELECT distinct GBRCS_ITEMHIGHT from gbrcs WHERE GBRCS_ITEMHIGHT<>'0' AND GBRCS_ITEMHIGHT<>'' ORDER BY GBRCS_ITEMHIGHT ASC", $sql_con); while ($egy_sor = mysql_fetch_row($abroncs_result_meret2)) { foreach ($egy_sor as $ertek) { $abroncs_meret2 = $abroncs_meret2 . '\n"; } } $abroncs_result_meret3 = mysql_query("SELECT distinct GBRCS_ITEMCALIBER from gbrcs WHERE GBRCS_ITEMCALIBER<>'0' AND GBRCS_ITEMCALIBER<>'' ORDER BY GBRCS_ITEMCALIBER ASC", $sql_con); while ($egy_sor = mysql_fetch_row($abroncs_result_meret3)) { foreach ($egy_sor as $ertek) { $abroncs_meret3 = $abroncs_meret3 . '\n"; } } /*$afelni_result_gyarto = mysql_query("SELECT distinct LFLNI_TYPE from lflni ORDER BY LFLNI_TYPE ASC", $sql_con); while ($egy_sor = mysql_fetch_row($afelni_result_gyarto)) { foreach ($egy_sor as $ertek) { $afelni_gyarto = $afelni_gyarto . '\n"; } } $afelni_result_meret1 = mysql_query("SELECT distinct LFLNI_ITEMWIDTH from lflni ORDER BY LFLNI_ITEMWIDTH ASC", $sql_con); while ($egy_sor = mysql_fetch_row($afelni_result_meret1)) { foreach ($egy_sor as $ertek) { $afelni_meret1 = $afelni_meret1 . '\n"; } } $afelni_result_meret2 = mysql_query("SELECT distinct LFLNI_ITEMHIGHT from lflni ORDER BY LFLNI_ITEMHIGHT ASC", $sql_con); while ($egy_sor = mysql_fetch_row($afelni_result_meret2)) { foreach ($egy_sor as $ertek) { $afelni_meret2 = $afelni_meret2 . '\n"; } }*/ //Gumiabroncs elso 25 kedvezmenyes aru termek novekvo sorrendben $abroncs_result_best25price = mysql_query("SELECT GBRCS_TYPE, GBRCS_DESC, GBRCS_ITEMID, GBRCS_PRICE from gbrcs WHERE GBRCS_ITEMWIDTH<>'0' AND GBRCS_ITEMWIDTH<>'' AND GBRCS_ITEMHIGHT<>'0' AND GBRCS_ITEMHIGHT<>'' AND GBRCS_ITEMCALIBER<>'0' AND GBRCS_ITEMCALIBER<>'' ORDER BY GBRCS_PRICE ASC LIMIT 25", $sql_con); //$abroncs_result_best25price = mysql_query("SELECT GBRCS_TYPE, GBRCS_DESC, GBRCS_ITEMID, GBRCS_PRICE from gbrcs WHERE GBRCS_ALLOW='I' ORDER BY GBRCS_PRICE ASC LIMIT 25", $sql_con); $even_cnt = 0; while ($egy_sor_tomb = mysql_fetch_array($abroncs_result_best25price)) { if ($even_cnt == 0) { $abroncs_best25price = $abroncs_best25price . " "; $picname = "cart_tablazathoz_gray.jpg"; } else { $abroncs_best25price = $abroncs_best25price . ' '; $picname = "cart_tablazathoz_white.jpg"; } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 4) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,1) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],1,3); } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 5) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,2) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],2,3); } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 6) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,3) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],2,3); } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 7) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,1) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],1,3) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],4,3); } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 8) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,2) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],2,3) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],5,3); } if (strlen($egy_sor_tomb["GBRCS_PRICE"]) == 9) { $ar_formazott = substr($egy_sor_tomb["GBRCS_PRICE"],0,3) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],3,3) . '.' . substr($egy_sor_tomb["GBRCS_PRICE"],6,3); } $abroncs_best25price = $abroncs_best25price . 'Kosárba teszem! ' . $egy_sor_tomb["GBRCS_DESC"] . '' . $ar_formazott . '.-'; $abroncs_best25price = $abroncs_best25price . "\n"; if ($even_cnt == 0) { $even_cnt = 1; } else { $even_cnt = 0; } $ar_formazott = ""; } ?> Hegedűs Kft. - gumi, felni, futómű

 

 

 

 

HA OLYAN MÁRKÁT KERES, AMIT NEM TALÁL A KERESŐBEN, ARRÓL SZÍVESKEDJÉK ÉRDEKLŐDNI TELEFONON! MOTORGUMI ÉS TEHERGUMI RENDELÉSRE!

akciós gumiköpenyek
Név Akciós ár
Kerékcsavarok nagy választékban, minden autótípushoz!