[Resolved] Can someone please correct this mysql query?

[nicknax]

$sql = "UPDATE playerstable SET wins = '$wins', draws = '$draws', losses = '$losses', deadline = '$deadline', points = '($wins 3) + ($draws 1) + ($losses * -1)' WHERE player_id = '$id'";

I want the points table to add wins times 3, draws times 1, losses times minus 1.

[halojoy]

sure they can
and they will
but you know about me 😉
'I am from Barcelona!'

[nicknax]

that doesn't really help 🙁

[Weedpacket]

Yes, someone can correct that MySQL query. But first, what have you done to correct it yourself, and what were the results? What debugging have you done and what were the results? And what was the problem again?

It's probably all those spurious apostrophes.

[nicknax]

hey, last attempt fixed it!

answer was:

UPDATE playerstable SET wins = '$wins', draws = '$draws', losses = '$losses', deadline = '$deadline', points = $wins 3 + $draws 1 + $deadline * -1 WHERE player_id = '$id";

removed quotes and space teh maths out a lil bit for the points part of the query.