MySQL Forums
Forum List  »  Newbie

Problem with UPDATE Statement
Posted by: Lehmann Manuel
Date: April 04, 2005 02:14AM

Hallo....
Mein Update Befehl funktioniert nicht, aber erst wenn mehrere Einträge betroffen sind.
Wenn ich nur einen Eintrag "update" funktioniert es!
Hoffe mal mir kann jemand helfen!!!
Der Code:
$Query1 = "UPDATE IGNORE t_material SET
BwNr = $BwNr,
SecoStatus = $SecoStatus,
ErstellDatum = $ErstellDatum,
AusfuhrDat = $AusfuhrDat,
GültikDatum = $GültikDatum,
BewDatum = $BewDatum,
VerlDatum = $VerlDatum,
Abgelaufen = $Abgelaufen,
TotWert = $TotWert,
TotGew = $TotGew,
NettoGew1 = $NettoGew1,
NettoGew2 = $NettoGew2,
NettoGew3 = $NettoGew3,
NettoGew4 = $NettoGew4,
NettoGew5 = $NettoGew5
Wert1 = $Wert1,
Wert2 = $Wert2,
Wert3 = $Wert3,
Wert4 = $Wert4,
Wert5 = $Wert5
WHERE IntNr = $IntNr";
$result1 = mysql_query($Query1) or die( "<strong>ERROR: Query1 failed <hr> $Query3 </strong>" );

Options: ReplyQuote


Subject
Written By
Posted
Problem with UPDATE Statement
April 04, 2005 02:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.