mysql_query() syntax

[theoneweasel77]

I'm getting an error on the following mysql_query()

$result = mysql_query("select $move from moves where game_num = '$ID' && color = 'blue'", $db);

the error output 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 'from moves where game_num = '1' && color = 'blue'' at line 1

All variables are set, $db is a valid mysql link resource, the table exists and the column names are correct. There is data in the row I'm looking for. The following similar query works:

$result = mysql_query("select $moves[$i] from game_board where game_num = '$ID' && color = '$color2'", $db);

I don't know what I did wrong...

[LordShryku]

Echo the query before executing it. It's obviously haveing trouble with $move.

[FMB]

$result = mysql_db_query($db, "select " . $move . " from moves where game_num = '" . $ID. "' && color = 'blue'") or die("Error : " . mysql_error());

Try that and tell us the error if that doesn't work.

[superwormy]

What is in the variable $moves?

Is it a field name, or list of field names, or a '*'? It should be...

Try something like:
SELECT * FROM moves ...