god dam werid error

[NoRp]

$query = "UPDATE tablename SET games='$games', for='$fornew', agasint='$agasintnew' WHERE teamid = '$team2id' ";
$result = mysql_query($query) or die("something wrong when updateding players." .mysql_error() );

and the error i get is

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 'for='5', agasint='10' WHERE teamid = '2'' at line 1

the thing is i know the code is correct because i use the exact same WHERE statment like a million times. its almosty like the code is finding an extra ' from the middle of no where ive tried deleting the ' in my code but i still get a simlar error

any ideas are welcome! 😕 !!!

[bpat1434]

I think it's actually running into an error around here:
SET games='$games', for='$fornew',

What you can do is structure your code like this:

 $query = "UPDATE tablename 
SET games='$games', for='$fornew', agasint='$agasintnew' 
WHERE teamid = '$team2id' "; 

Then, when your sql error spits out, it will say "Line X" and then you have 3 lines to look at rather than one line with the error being anywhere.

~Brett

[coreyp_1]

"for" is a MySQL Reserved Word.

Enclose it in the backtick (`) character (not an apostraphe).

[NoRp]

which part needs to be enclosed in ive tried swoping the ' fors but still getting same error

[NoRp]

man i love you guys thanks so much!!!