php - 此查询中的 SQL 语法错误在哪里？

Question

mysqli_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 'group, uploaded_by, date_uploaded, url) VALUES (1, 1, NOW(), '/gallery/1/h' at line 2

但这是生成的 SQL 查询

INSERT INTO
gallery_images (group, uploaded_by, date_uploaded, url)
VALUES (1, 1, NOW(), '/gallery/1/halflife2180z97stmydo1600x1200.jpg')

它实际上与我在同一站点上运行的另一个 SQL 查询完全相同，没有错误。

如果我试图在 MySQL 中的字段中插入无效值，我会理解，但它清楚地指出我有一个语法错误，而我就是看不到它。

看到就回复吧。下面是查询背后的 PHP

---

$res = $con->query("
        INSERT INTO
        gallery_images (group, uploaded_by, date_uploaded, url)
        VALUES ($group, {$_SESSION[user]->id}, NOW(), '$escaped_name')
    ");

Answer 1

group 是保留关键字。在它周围加上反引号。

$res = $con->query("
        INSERT INTO
        gallery_images (`group`, uploaded_by, date_uploaded, url)
        VALUES ($group, {$_SESSION[user]->id}, NOW(), '$escaped_name')
    ");