Hallo Leute,
ich finde den fehler leider nicht. Bekomme in der Schleife immer die folgende Meldung.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in XXXXXXXXXXX/phpprog.php on line 43
PHP-Code:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
include("dbconnect.php");
$trennnr =$_GET['trennnr'];
$abfrage = "SELECT Rennen, Startbahn, Verein, S1, S2, S3, S4, E1, E2, E3, E4, S9 FROM fes12_mannschaften WHERE Rennen='$trennnr' ";
echo "<HR>$trennnr<HR>";
echo "<HR>$abfrage<HR>";
#$ergebnis =mysql_db_query($db,$teams);
$ergebnis =mysql_query($abfrage);
echo "<TABLE BGCOLOR='#CCCCCC' CELLSPACING=1 CELLPADDING=5>";
echo "<TR>";
echo "<TD BGCOLOR='#EEEEEE'>Bahn</TD>";
echo "<TD BGCOLOR='#EEEEEE'>Mannschaft</TD>";
echo "<TD BGCOLOR='#EEEEEE'>Ersatz</TD>";
echo "<TD BGCOLOR='#EEEEEE'>Verein</TD>";
echo "</TR>";
while($trow = mysql_fetch_row($ergebnis)){
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF'>$trow[1] </TD>";
#Sportler1
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[3] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts1name=$tzeile[1];
$ts1vorname=$tzeile[2];
#Sportler2
$tquery2 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery2.=" AND Nummer=$trow[4] ";
$result2 =mysql_query($tquery2);
$tzeile2 = mysql_fetch_row($result2);
$ts2name=$tzeile2[1];
$ts2vorname=$tzeile2[2];
#Sportler3
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[5] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts3name=$tzeile[1];
$ts3vorname=$tzeile[2];
#Sportler4
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[6] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts4name=$tzeile[1];
$ts4vorname=$tzeile[2];
#Sportler5
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[7] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts5name=$tzeile[1];
$ts5vorname=$tzeile[2];
#Sportler6
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[8] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts6name=$tzeile[1];
$ts6vorname=$tzeile[2];
#Sportler7
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[9] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts7name=$tzeile[1];
$ts7vorname=$tzeile[2];
#Sportler8
$tquery1 ="SELECT Nummer, Name, Vorname FROM fes12_sportler WHERE 1 ";
$tquery1.=" AND Nummer=$trow[10] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$ts8name=$tzeile[1];
$ts8vorname=$tzeile[2];
If ($ts2name == "") {
echo "<TD BGCOLOR='#5BBE00'>$ts1vorname $ts1name</TD>";
echo "<TD BGCOLOR='#FFFFFF'>$ts5vorname $ts5name</TD>";
}else{
If ($ts4name=="") {
echo "<TD BGCOLOR='#FFFFFF'>$ts1vorname $ts1name</br>$ts2vorname $ts2name</TD>";
echo "<TD BGCOLOR='#FFFFFF'>$ts5vorname $ts5name</br>$ts6vorname $ts6name</TD>";
}else{
echo "<TD BGCOLOR='#FFFFFF'>$ts1vorname $ts1name</br>$ts2vorname $ts2name</br>$ts3vorname $ts3name</br>$ts4vorname $ts4name</TD>";
echo "<TD BGCOLOR='#FFFFFF'>$ts5vorname $ts5name</br>$ts6vorname $ts6name</br>$ts7vorname $ts7name</br>$ts8vorname $ts8name</TD>";
}}
$tquery1 ="SELECT Nummer, Kurzname FROM fes12_teilnehmendevereine WHERE 1 ";
$tquery1.=" AND Nummer=$trow[2] ";
$result =mysql_query($tquery1);
$tzeile = mysql_fetch_row($result);
$tverein=$tzeile[1];
echo "<TD BGCOLOR='#FFFFFF'>$tverein</TD>";
echo "</TD>";
echo "</TR>";
}
echo "</TABLE>";
?>
Ich hoffe ihr könnt mir helfen.