No connect to Database!"; exit; } mysql_select_db($db_dsn, $db); $breadcrumb = ''; $breadcrumb_temp_1 = ''; $breadcrumb_temp_2 = ''; $breadcrumb_temp_3 = ''; $i = 0; if ($kat) { // 1. Ebene $sql_kat = "SELECT * FROM peweta_product_kategorie WHERE id = ".$kat." "; $result_kat = mysql_query($sql_kat) or die (mysql_error()); $dbrow_kat = mysql_fetch_assoc($result_kat); $kat_titel = strip_tags($dbrow_kat['titel_en']); $kat_text = strip_tags($dbrow_kat['text_en']); $anzahl_spalten = $dbrow_kat['spalten']; if ($dbrow_kat['logo'] == '0') $logo = 'ydot.gif'; if ($dbrow_kat['logo'] == 'ex') $logo = 'ex22.gif'; if ($dbrow_kat['logo'] == 'ball') $logo = 'ballsafe.gif'; if ($dbrow_kat['logo'] == 'knx') $logo = 'knx51.gif'; $breadcrumb_temp_1 = " > ".$kat_titel.""; // 2. Ebene if ($dbrow_kat['vater'] > 0) { $sql_okat = "SELECT * FROM peweta_product_kategorie WHERE id = ".$dbrow_kat['vater']." "; $result_okat = mysql_query($sql_okat) or die (mysql_error()); if ($dbrow_okat = mysql_fetch_assoc($result_okat)) { $okat_titel = strip_tags($dbrow_okat['titel_en']); $okat_text = strip_tags($dbrow_okat['text_en']); $okat_vater = $dbrow_okat['vater']; $breadcrumb_temp_2 = " > ".$okat_titel.""; } } // 3. Ebene if ($okat_vater > 0) { $sql_ookat = "SELECT * FROM peweta_product_kategorie WHERE id = ".$okat_vater." "; $result_ookat = mysql_query($sql_ookat) or die (mysql_error()); if ($dbrow_ookat = mysql_fetch_assoc($result_ookat)) { $ookat_titel = strip_tags($dbrow_ookat['titel_en']); $ookat_text = strip_tags($dbrow_ookat['text_en']); $breadcrumb_temp_3 = " > ".$ookat_titel.""; } } } if (!$anzahl_spalten) $anzahl_spalten = '5'; if (!$logo) $logo = 'ydot.gif'; ?> PEWETA Product Range

Product Range

 


More Products '.$sql.''); $db_result = mysql_query($sql); // odbc_fetch_row($db_result); if (mysql_num_rows($db_result) > 0) { ?>
product choice
0) { $sql = "SELECT * FROM peweta_product_uebersicht WHERE produkt_kategorie = '".$kat."' AND aktiv_en = 1 ORDER BY sort"; $artikel = 1; } else { $sql = "SELECT * FROM peweta_product_kategorie WHERE vater = ".$kat." AND aktiv_en = 1 ORDER BY sort"; } } else { $sql = "SELECT * FROM peweta_product_kategorie WHERE aktiv_en = 1 AND vater = 0 ORDER BY sort"; } $result = mysql_query($sql) or die (mysql_error()); while($dbrow = mysql_fetch_assoc($result)) { ($dbrow['bild_en']) ? $bild = $dbrow['bild_en'] : $bild = $dbrow['bild']; if (!$bild) $bild = 'dummy.jpg'; if ($dbrow['logo'] == '0') $logo = 'ydot.gif'; if ($dbrow['logo'] == 'ex') $logo = 'ex22.gif'; if ($dbrow['logo'] == 'ball') $logo = 'ballsafe.gif'; if ($dbrow['logo'] == 'knx') $logo = 'knx22.gif'; if (!$logo) $logo = 'ydot.gif'; if ($dbrow['vater'] > 0) { $parameter = "kat=".$dbrow['id']."&vater=".$dbrow['vater']; } else { $parameter = "kat=".$dbrow['id']; } if($dbrow['typreihe_en']){ $type_text = $dbrow['typreihe_en']; } else { $type_text = $dbrow['typreihe']; }; $link = ''; if ($artikel == 1) { if ($dbrow['pdf_en']) $link = ""; // echo $bild; if (is_file("/home/pewetdbx/www.peweta.de/artikel/bild600/".$bild)) { $img = "\"Enlarge"; } else { $img = "\"No"; } } else { $link = ""; $img = $link."".$dbrow["; } if ($i == $anzahl_spalten) { $i = 0; ?>
Type series
";?>".nl2br($dbrow['text_en'])."";?>
PDF PDF download