[RESOLVED] Syntax error?

[jamesjohnson88]

I am getting 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 'Points = Points-11 WHERE PlayerName = 'Bjorn' LIMIT 1' at line 1.

I don't really see anything wrong it. Is it the syntax or is it something else?

Any help would be appreciated.

if ($var8 =! 0)
	{
		mysql_query("UPDATE $leagueName SET Times_1st = Times_1st-1 Points = Points-11 WHERE PlayerName = '$player1' LIMIT 1") or die(mysql_error());
		mysql_query("UPDATE $leagueName SET Times_2nd = Times_2nd-1 Points = Points-8 WHERE PlayerName = '$player2' LIMIT 1") or die(mysql_error());
		mysql_query("UPDATE $leagueName SET Times_3rd = Times_3rd-1 Points = Points-5 WHERE PlayerName = '$player3' LIMIT 1") or die(mysql_error());
		mysql_query("UPDATE $leagueName SET Points = Points-2 WHERE PlayerName='$player4'") or die(mysql_error());
	}

[NogDog]

First thing I see is that you need a comma between each "column = value" pair in the SET clause.

[jamesjohnson88]

Thanks man, I totally forgot about those. Oh well, guess thats how you learn.

Much appreciated.

[NogDog]

No problem.

Don't forget to mark this thread "resolved" (if it is) via the "Thread Tools" link near the top. 🙂

[jamesjohnson88]

Oops, yeah. Sorry about that. Close the tab after I posted the message -_-*