query("select * from modelle,hersteller where modelle.id like '$_GET[nr]' and modelle.hersteller=hersteller.kuerzel") or die(mysql_error()); while ($row1 = $result1->fetch_object()) { $vorhanden3=$row1->kupplungnr; $vorhanden4=$row1->pantonr; $vorhanden5=$row1->raedernr; $vorhanden7=$row1->pantoet; echo ""; echo "Modellzusatzinformationen $row1->typ, Katalognummer $row1->katnr_vor $row1->katnr_haupt $row1->katnr_kk $row1->katnr_nach"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
 

bildpfad/$row1->modellbilder\".jpg\"\" width=675 border=0>

 
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // Pr�fen, ob Infotext1 vorliegt if ($row1->infonr=='') echo "
"; else { $result2 = $connectionMYSQLI->query("select * from infoseiten where infoseiten.infonr like '$row1->infonr'") or die(mysql_error()); while ($row2 = $result2->fetch_object()) { $vorhanden1=$row2->infotext1; $vorhanden2=$row2->infotext2; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } // Pr�fen, ob Infotext2 vorliegt if ($vorhanden2=='') echo ""; else { echo ""; } } // Pr�fen, ob Kupplung1 vorliegt if ($vorhanden3=='') echo ""; else { $result3 = $connectionMYSQLI->query("select * from kupplung where kupplung.kupplungnr like '$vorhanden3'") or die(mysql_error()); while ($row3 = $result3->fetch_object()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } // Pr�fen, ob Panto1 vorliegt if ($vorhanden4=='') echo ""; else { $result4 = $connectionMYSQLI->query("select * from panto where panto.pantonr like '$vorhanden4'") or die(mysql_error()); while ($row4 = $result4->fetch_object()) { echo ""; echo ""; echo ""; echo ""; else { $result7 = $connectionMYSQLI->query("select * from stromabnehmer where artikelnr like '$vorhanden7'") or die(mysql_error()); while ($row7 = $result7->fetch_object()) { echo " (Beschreibung: artikelnr\">$row7->artikelnr oder Gesamtliste)"; } } echo ""; echo ""; echo ""; echo ""; echo ""; } } // Pr�fen, ob Raeder1 vorliegt if ($vorhanden5=='') echo ""; else { $result5 = $connectionMYSQLI->query("select * from raeder where raeder.raedernr like '$vorhanden5'") or die(mysql_error()); while ($row5 = $result5->fetch_object()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo ""; ?>
   
  Zusatzinformation:  $vorhanden1
   
    Erkl�rung zur Zusatzinformation:
    $vorhanden2
     
  Kupplungen: $row3->kupplung1
   
  Geh�use/Stromabnehmer/Diverses: $row4->panto1"; if ($vorhanden7=='') echo "
   
  Beschreibung: $row5->raeder1