mysql_query() not working

[theoneweasel77]

assuming all variables are set and $db is a valid link resource and mysql_error() returns nothing and the table exists with the specified column names, what is wrong with the following statement?

$piece_update = mysql_query("UPDATE `moves` SET `$move_from` = '$moves[$foo]', `$move_to` = '$moves[$foo2]' WHERE `ID` = '$ID' && `color` = '$color'", $db);

and I've tried this

$piece_update = mysql_query("UPDATE `moves` SET '$move_from' = '$moves[$foo]', '$move_to' = '$moves[$foo2]' WHERE `ID` = '$ID' && `color` = '$color'", $db);

The data is never entered in the database.

 

[theoneweasel77]

the second code block produces an error.

 

[theoneweasel77]

nevermind again . I was looking for help in the mysql forum and as I was explaining that all the variables were set I got to thinking...maybe they're not. Turns out I forgot to pass a session ID in the query string