update im array ???

[voodoo]

Weiss jemand ob und warum die "update ghostwm set WM_Punkte=$wm where ID=$daten[ID];" Zeile nicht funktioniert? Geht es innerhalb dieses arrays überhaupt?

<?php
$result=mysql_query("SELECT ID,Platz,Zeit,Fahrername,WM_Punkte,Ghost_Punkte,Steuerung,Ghostfile FROM ghostwm WHERE Jahr='2002' and Strecke='Australien' ORDER BY Zeit");
$i=1;
print
('<table border="1" align="center" width="300" cellspacing="1" style="border-style: ridge; font-family:Times New Roman; font-size:11pt; font-weight:bold">');
while ($daten=mysql_fetch_array($result))
{
if ( $i == 1 ){ $wm = 10 ; $ghost = 15;}
elseif ( $i == 2 ){ $wm = 6 ; $ghost = 14;}
elseif ( $i == 3 ){ $wm = 4 ; $ghost = 13;}
elseif ( $i == 4 ){ $wm = 3 ; $ghost = 12;}
elseif ( $i == 5 ){ $wm = 2 ; $ghost = 11;}
elseif ( $i == 6 ){ $wm = 1 ; $ghost = 10;}
elseif ( $i == 7 ){ $wm = 0 ; $ghost = 9;}
elseif ( $i == 8 ){ $wm = 0 ; $ghost = 8;}
elseif ( $i == 9 ){ $wm = 0 ; $ghost = 7;}
elseif ( $i == 10 ){ $wm = 0 ; $ghost = 6;}
elseif ( $i == 11 ){ $wm = 0 ; $ghost = 5;}
elseif ( $i == 12 ){ $wm = 0 ; $ghost = 4;}
elseif ( $i == 13 ){ $wm = 0 ; $ghost = 3;}
elseif ( $i == 14 ){ $wm = 0 ; $ghost = 2;}
elseif ( $i == 15 ){ $wm = 0 ; $ghost = 1;}
else{ $wm = 0; $ghot = 0;}
update ghostwm set WM_Punkte=$wm where ID=$daten[ID];
print("
<tr>
<td align='center' bgcolor='#FFCC00'>$i.</td>
<td align='left' bgcolor='#FFCC00'>$daten[ID]</td>
<td align='left' bgcolor='#FFCC00'>$daten[Zeit]</td>
<td align='center' bgcolor='#FFCC00'>$daten[Fahrername]</td>
<td align='center' bgcolor='#FFCC00'>$wm</td>
<td align='center' bgcolor='#FFCC00'>$ghost</td>
<td align='left' bgcolor='#FFCC00'>$daten[Steuerung]</td>
<td align='center' bgcolor='#FFCC00'>$daten[Ghostfile]</td>
</tr>
");
$i++;
}
print ('</table>');
?>

[GWC]

Hi,
versuchs mal so:

<?php 
$result=mysql_query("SELECT ID,Platz,Zeit,Fahrername,WM_Punkte,Ghost_Punkte,Steuerung,Ghostfile FROM ghostwm WHERE Jahr='2002' and Strecke='Australien' ORDER BY Zeit"); 
$i=1; 
print 
('<table border="1" align="center" width="300" cellspacing="1" style="border-style: ridge; font-family:Times New Roman; font-size:11pt; font-weight:bold">'); 
while ($daten=mysql_fetch_array($result)) 
{ 
if ( $i == 1 ){ $wm = 10 ; $ghost = 15;} 
elseif ( $i == 2 ){ $wm = 6 ; $ghost = 14;} 
elseif ( $i == 3 ){ $wm = 4 ; $ghost = 13;} 
elseif ( $i == 4 ){ $wm = 3 ; $ghost = 12;} 
elseif ( $i == 5 ){ $wm = 2 ; $ghost = 11;} 
elseif ( $i == 6 ){ $wm = 1 ; $ghost = 10;} 
elseif ( $i == 7 ){ $wm = 0 ; $ghost = 9;} 
elseif ( $i == 8 ){ $wm = 0 ; $ghost = 8;} 
elseif ( $i == 9 ){ $wm = 0 ; $ghost = 7;} 
elseif ( $i == 10 ){ $wm = 0 ; $ghost = 6;} 
elseif ( $i == 11 ){ $wm = 0 ; $ghost = 5;} 
elseif ( $i == 12 ){ $wm = 0 ; $ghost = 4;} 
elseif ( $i == 13 ){ $wm = 0 ; $ghost = 3;} 
elseif ( $i == 14 ){ $wm = 0 ; $ghost = 2;} 
elseif ( $i == 15 ){ $wm = 0 ; $ghost = 1;} 
else{ $wm = 0; $ghot = 0;} 
[b]mysql_query("update ghostwm set WM_Punkte='$wm' where ID='$daten[ID]'");[/b]
print(" 
<tr> 
<td align='center' bgcolor='#FFCC00'>$i.</td> 
<td align='left' bgcolor='#FFCC00'>$daten[ID]</td> 
<td align='left' bgcolor='#FFCC00'>$daten[Zeit]</td> 
<td align='center' bgcolor='#FFCC00'>$daten[Fahrername]</td> 
<td align='center' bgcolor='#FFCC00'>$wm</td> 
<td align='center' bgcolor='#FFCC00'>$ghost</td> 
<td align='left' bgcolor='#FFCC00'>$daten[Steuerung]</td> 
<td align='center' bgcolor='#FFCC00'>$daten[Ghostfile]</td> 
</tr> 
"); 
$i++; 
} 
print ('</table>'); 
?>

MfG

[voodoo]

Klaro, nur einen SQL Befehl einzugeben kann ja nicht funktionieren. Danke, jetzt klappt es auch.