[Resolved] [Resolved] Simple Update syntax problem

[genom]

Okay i've checked around and think that perhaps my code may be at fault rather than the sql statement.

$update = "UPDATE mcw SET Name='$name2', Group='$group2', Position='$position2' WHERE Name='$name1'";

I've echoed back the sql and that gives me this from my code

UPDATE mcw SET Name='Rhhomi', Group='Crafter', Position='Bard' WHERE Name='Rhhomi' 

I've checked my spelling a dozen times already but it won't update the database when I run it through.

mysql_query($update) or die("Bug Report Please - " . mysql_error() . " ---- " . $update);

I keep getting the following error thrown back at me.

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 'Group='Crafter', Position='Bard' WHERE Name='Rhhomi'

Any ideas what i'm doing wrong, although I suspect it's likely something stupid.

[TheDefender]

GROUP is a reserved word in MySQL (GROUP BY clause), so the query thinks it is trying to do a GROUP BY and freaks out when the code doesn't jive with it. Rename that field to something else (like Group1 or something) and see if that doesn't work any better for you.

[genom]

Cool, that sorted it, I was right it was a stupid mistake.

Thanks.