mysqli选择查询错误1064

Question

trying to make a query:

$word = $mysqli->real_escape_string($words[$value]);
$valor = $mysqli->real_escape_string($value);

$query = $mysqli->query("SELECT 'w_id' FROM '$valor' WHERE word='$word'");

But the result is :

Error (1064) 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 ''eng' WHERE word='msms'' at line 1

here eng is a value of $valor

I tried allready a lot of possibilities to insert the variable, and changed names of tables, but nothing helps

tried '".$valor."' as well

Answer 1

Do not put quotation marks around the table/field names:

$query = $mysqli->query("SELECT w_id FROM " . $valor . " WHERE word = '" . $word . "'");