php - mysql查询奇怪的错误

Question

当其他相同的页面运行良好但另一个在相同的查询代码上给出错误时我收到错误。

这是我的代码，这有什么问题吗？

$ttt = mysql_query("SELECT * FROM like WHERE (user_id='$user_id' AND sound_id='$sound_id')",$link) or die(mysql_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 'like WHERE (user_id='' AND sound_id='')' at line 1

Answer 1

like 是一个 SQL reserved word你应该在反引号内使用“like”``

$ttt = mysql_query("SELECT * FROM `like` WHERE (user_id='$user_id' AND sound_id='$sound_id')",$link) or die(mysql_error());