error in update

[TRICKY]

Hi guys

The code gives me this error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' wars.score_own = 1 WHERE wars.id=26, wars.score_oppone

The Code:

$query="UPDATE played_locations AS pl,
wars AS wars
SET pl.location_id = CASE
WHEN pl.for_war=26 AND pl.round=1 THEN 3
WHEN pl.for_war=26 AND pl.round=2 THEN 3 END,
pl.opponent_score = CASE
WHEN pl.for_war=26 AND pl.round=1 THEN 73
WHEN pl.for_war=26 AND pl.round=2 THEN 78 END,
pl.own_score = CASE
WHEN pl.for_war=26 AND pl.round=1 THEN 80
WHEN pl.for_war=26 AND pl.round=2 THEN 80 END,
wars.finished = 1 WHERE wars.id =".$war_id.",
wars.score_own = ".$total_own_score." WHERE war -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[crimson]

It looks to me as if though you I notice you have posted your PHP code which generates the SQL. Try posting an example of an actual query generated by this PHP code. (echo $query;, copy & paste here)

bye
Good luck -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[snorter]

I did a WHERE clause after every column i set to a value.
I think only 1 WHERE clause should be on the end.
Or maybe that wasnt the problem, Anyhow its fixed now. Here's the new query when i echo it out:

Code:

UPDATE played_locations AS pl,
wars AS wars
SET pl.location_id = CASE
WHEN pl.round = 1 THEN 1
WHEN pl.round = 2 THEN 2
END,
pl.opponent_score = CASE
WHEN pl.round = 1 THEN 2
WHEN pl.round = 2 THEN 4
END,
pl.own_score = CASE
WHEN pl.round = 1 THEN 4
WHEN pl.round = 2 THEN 5
END,
wars.finished = 1,
wars.score_own = 0,
wars.score_opponent = 0
WHERE wars.id=26

Bye and -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --