无法弄清楚mySQL语法错误的来源

I'm working on a private messaging system between users on my site. Here's my query:

我正在我的网站上的用户之间开发一个私人消息系统。这是我的查询：

$query = "INSERT INTO messages (to, `from`, message) VALUES ('{$user}', '{$username}', '{$message}')";

However, I get 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 'to, `from`, message) VALUES ('Cheezey', 'Cheezey', 'Enter your message here')' at line 1

I have a nagging feeling that it's a really stupid error on my part, but I can't seem to figure it out.

我有一种唠叨的感觉，这对我来说是一个非常愚蠢的错误，但我似乎无法弄明白。

1 个解决方案

#1

That's because to is a reserved word in MYSQL, you have to put ` around it, like this:

那是因为在MYSQL中是一个保留字，你必须把它放在它周围，就像这样：

 INSERT INTO(`to`, ...).

1 个解决方案

#1

更多相关文章

随机推荐