[SOLVED] More Update problems!!

[almightyegg]

$update = mysql_query("UPDATE ranks (`name`, `color`, `mod`, `invite`, `ban`, `give`, `edit`, `kick`, `changerank`, `editrank`)
	VALUES('$name', '$color', '$mod', '$invite', '$ban', '$give', '$edit', '$kick', '$changerank', '$editrank') WHERE society='$id' AND rank='$rank'") or die(mysql_error());

 

it errors: 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 '(`name`, `color`, `mod`, `invite`, `ban`, `give`, `edit`, `kick`, `changerank`, ' at line 1

[frost]

try adding a single quote around ranks?

 

 $update = mysql_query("UPDATE `ranks` 

[almightyegg]

no change

[frost]

Here is a bit of code I wrote that I know works, it looks like what you have here is for INSERT?

 

$sql = "UPDATE `categories` SET category='$category',intro='$intro' WHERE id = '$theid'";
$result = mysql_query($sql);

 

I think you need the SET command?

[almightyegg]

I still get the error

$update = mysql_query("UPDATE ranks SET name='$name',color='$color',mod='$mod',invite='$invite',ban='$ban',give='$give,edit='$edit,kick='$kick',changerank='$changerank',editrank='$editrank' WHERE society='$id' and rank='$rank'") or die(mysql_error());

 

Maybe it's because of my WHERE queries? As I have 2 of them...?

[almightyegg]

$update = mysql_query("UPDATE ranks SET name='{$name}',color='{$color}',mod='{$mod}',invite='{$invite}',ban='{$ban}',give='{$give}',edit='{$edit}',kick='{$kick}',changerank='{$changerank}',editrank='{$editrank}' WHERE society='{$id}',rank='{$rank}'") or die(mysql_error());

 

This is where I'm at now, still get this:

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 'mod='Yes',invite='No',ban='Yes',give='Yes',edit='No',kick='22',changerank='0',ed' at line 1

[almightyegg]

I managed to fix it, it seemed it was recognising the column name as something else