error in my query

[ohdang888]

From the code below, 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 ''1' = 0 WHERE `id`='5'' at line 1

 

whats wrong with my query?

 

BTW, in this case, $field = 1

if($action = 'deny'){
mysql_connect("localhost", "root", "pancakes1") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());

mysql_query("UPDATE `friend_requests` SET '{$field}' = 0 WHERE `id`='{$id}' ") or die(mysql_error());

Echo 'Friend Request Successfully Denied';
}

[jandrews3]

Try:

"Update friend_requests SET field=0 WHERE id='$id'";

 

[ohdang888]

that won't work.

 

I have several columns, named, 1, 2, 3 etc..... So i need the column name to be stored in a variable.

[jandrews3]

Try:

"Update friend_requests SET '$field' = '$value' WHERE id='$id'";

[maxudaskin]

or just put the all in with AND between them